Download
a few tricks to take you beyond the basics of microsoft office n.
Skip this Video
Loading SlideShow in 5 Seconds..
A few tricks to take you beyond the basics of Microsoft Office PowerPoint Presentation
Download Presentation
A few tricks to take you beyond the basics of Microsoft Office

A few tricks to take you beyond the basics of Microsoft Office

115 Views Download Presentation
Download Presentation

A few tricks to take you beyond the basics of Microsoft Office

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. A few tricks to take you beyond the basics of Microsoft Office GCPS Tech Tips Microsoft Excel: Adding a comment to a worksheet.

  2. EXCEL: Adding a comment to a text box Sometimes you may want to add a comment to certain parts of an Excel worksheet. There are two ways to do that with ease.

  3. EXCEL: Adding a comment to a text box To add a comment to any cell in your worksheet, put your cursor on that cell... and then click “Insert” at the top of your screen.

  4. EXCEL: Adding a comment to a text box On the menu that drops down, click on “Comment.”

  5. EXCEL: Adding a comment to a text box Excel will insert a comment text box for you.

  6. EXCEL: Adding a comment to a text box Type in your comment text...

  7. EXCEL: Adding a comment to a text box and click anywhere outside of the comment box.

  8. EXCEL: Adding a comment to a text box Excel will leave a tiny red triangle in the upper right corner of the cell that has your comment.

  9. EXCEL: Adding a comment to a text box Any time you place your cursor on that triangle, your comment will reappear.

  10. EXCEL: Adding a comment to a text box Later... if you want to remove the comment... place your cursor on the cell...

  11. EXCEL: Adding a comment to a text box and press the right button on your mouse.

  12. EXCEL: Adding a comment to a text box A box will appear with some things you can do... including deleting the comment.

  13. EXCEL: Adding a comment to a text box There’s also a method for adding a comment to any of the formulas in your worksheet... perhaps to remind you what that formula does.

  14. EXCEL: Adding a comment to a text box To add a comment to a formula, you use the N() function instead of a comment text box. N()

  15. EXCEL: Adding a comment to a text box Begin by clicking the cell that contains the formula you want to comment on.

  16. EXCEL: Adding a comment to a text box Click at the end of the Formula field.

  17. EXCEL: Adding a comment to a text box Type a plus sign... a letter N... a parenthesis open... and a parenthesis closed.

  18. EXCEL: Adding a comment to a text box Now... inside the two parentheses... type your comment... remembering to put a quotation mark at the beginning and end of your comment.

  19. EXCEL: Adding a comment to a text box When you press “Enter” Excel will add your comment to the formula...

  20. EXCEL: Adding a comment to a text box and place a little blue-green triangle in the upper left corner of the cell.

  21. EXCEL: Adding a comment to a text box The +N() function keeps your comment from affecting the formula’s actions... so the cell displays only the results of the formula. +N()

  22. EXCEL: Adding a comment to a text box Just be sure you remember to put your comment in quotes inside those parentheses. N(“”)

  23. EXCEL: Adding a comment to a text box That’s all there is to it. Now, if you would like a copy of the step-by-step directions for inserting comments in Excel worksheets, just print this last page. Have fun commenting!