Add Captions to Spreadsheets in Excel 2013

Add Captions to Spreadsheets in Excel 2013 covers the essential facts behind the topic, including what changed, why it mattered, and how it affected users.

To solve this problem, it is best to add annotations to spreadsheet cells. In this article will guide you to add annotations to the spreadsheet box in Excel 2013 located in the latest MS Office 2013 office suite of Microsoft.

Add Captions to Spreadsheets in Excel 2013

The formula N () allows you to add a comment directly into a spreadsheet cell. To use this function you just need to add a plus sign (+) at the end of the main formula and then enter a comment text string in quotation marks inside parentheses.

Meanwhile, the formula in the spreadsheet is still running normally but you will see the caption content inside the Funtion bar at the top.

Add a Caption to a Spreadsheet Box

With this feature, when dragging the mouse into a small popup panel, it will display immediately that spreadsheet containing the content you want to annotate. For example, in the illustrated example, a formula that takes random numbers from 1 to 49 and when someone moves the box, the sequence of taking random numbers is displayed to guide the viewer. Perform.

To add a caption to the spreadsheet box, simply select the box to comment, from the Ribbon menu above select the Review / New Comment tab or use Shift + F2.

Immediately a small popup will appear right there, you just need to edit the content inside that popup is okay.

Once you've finished editing, select any cell outside the selected cell to complete the operation. For spreadsheet cells with comments, a red triangle appears in the upper right corner of the worksheet.

If you don't want to comment on that spreadsheet anymore, simply right-click the box and select Delete Comment.

With the above tip, you can use it to guide your students in manipulating spreadsheets or annotations to avoid confusion when performing calculations on Excel.

Good luck!