Last updated on May 4th, 2023 at 11:12 am
It might seem strange to include a text box in a Microsoft Excel spreadsheet, but the versatility that you get with text box positioning can make it a really useful tool.
One interesting element of Excel text boxes is that they can interact with formulas in your cells.
Our tutorial below will show you how to display cell formulas in Excel 2013 text boxes if you are including important information in a text box that you have added to your worksheet.
How to Display a Formula Result in a Text Box in Excel 2013
- Open your Excel file.
- Enter the formula into an empty cell.
- Select the Insert tab.
- Click the Text Box button.
- Draw the text box.
- Click inside the text box.
- Click inside the Formula Bar.
- Type an equal sign, then click the cell with the formula and press Enter.
Our guide continues below with additional information on how to display cell formulas in Excel 2013 text boxes, including pictures of these steps.
While most of the data that you will typically work with in Excel will be entered into the cells of the spreadsheets, you may have scenarios where you use a text box instead.
Whether this is because the spreadsheet is being used for more than just data storage and manipulation, Excel provides you with these tools, and they can have a lot of utility.
But you may have discovered that there are some limitations to the text boxes that you use in Excel 2013.
Among these limitations is the fact that formulas entered into text boxes won’t calculate in the same way as formulas that you enter into cells.
However, you can take advantage of a linking feature that allows you to mirror the content of a cell inside a text box. Our article below will show you the steps needed to accomplish this.
Related: Check out our where is the formula bar in Excel article if you don’t see the formula bar on the excel screen.
How to Link a Text Box to a Cell in Excel 2013 (Guide with Pictures)
The steps in this article are going to show you how to display the contents of a cell inside a text box in an Excel 2013 spreadsheet.
Excel doesn’t let you enter formulas into a text box, but it does let you link a text box to a cell.
Therefore, you can put the formula into a cell in the spreadsheet, then link that cell to the text box. Our tutorial below will walk you through this process.
Step 1: Open your spreadsheet in Excel 2013.
Step 2: Click inside an empty cell in your spreadsheet and enter the formula whose result you want to display in the text box.
Step 3: Click the Insert tab at the top of the window.
Step 4: Click the Text Box button in the Text section of the ribbon.
Step 5: Draw the text box where you would like it to be displayed.
Step 6: Click inside the Formula Bar above the spreadsheet, type an “=” sign, then click the cell containing the formula that you want to display in the text box.
It should look something like the image below.
Once you are done, press the Enter key on your keyboard. The result of the formula should now be displayed in the text box.
If you adjust one of the values that is part of the formula, you will see that the formula result in the text box adjusts to mirror the value in the cell that it is mirroring.
Now that you know how to display cell formulas in Excel 2013 text boxes, you will be able to use this when you want to show specific information in a spreadsheet text box using the data produced by a formula.
Are you having difficulty printing the data in your spreadsheet? Read this Excel printing guide for some tips and suggestions on ways that you can reduce the amount of frustration that printing in Excel can cause.
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office, and many other popular applications and devices.