While it is customary to display data in Excel in the cells of the spreadsheet, situations can arise where you need to display your information in a way that will not affect the layout of the rest of your cells. An ideal solution to this is a text box, which can be customized independently of the rest of your data. You can even execute formulas in those text boxes, if you wish.
But text boxes have formatting that is separate from the other settings for your worksheet, and you may find that you have a text box that doesn’t have a border, but needs one. Our guide below will show you how to add a border to a text box in your Excel 2013 worksheet.
The steps below will assume that you already have a text box in your spreadsheet, and that it does not have a border. If you are instead interested in displaying gridlines on your spreadsheet, you can click here.
Here is how to add a border to a text box in Excel 2013 –
- Open your spreadsheet in Excel 2013.
- Click the text box to which you would like to add a border.
- Click the Format tab at the top of the window.
- Click the Shape Outline button in the Shape Styles section of the ribbon.
- Click the color that you would like to set for your border.
These steps are repeated below with pictures –
Step 1: Open your file in Excel 2013.
Step 2: Click the text box that you would like to have a border.
Step 3: Click the Format tab under Drawing Tools at the top of the window.
Step 4: Click the Shape Outline button in the Shape Styles section of the navigational ribbon.
Step 5: Click the color that you would like to use for the border. note that you can return to this location if you would like to set the width or style of your border.
If you decide later that you do not like the appearance of the text box with the border, then you can simply remove the border from the text box instead.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.