Day 04 of 100 Days Of Code in Data Analytics : Comments in Excel

Day 04 of 100 Days Of Code in Data Analytics : Comments in Excel

Excel comments are used to add a message to a cell or to clarify a formula. Editing, removing, and displaying or concealing comments on an Excel worksheet are all options available to users in Excel. The Excel comment box may also be resized and moved.

Screenshot (136).png

How to make a comment in Excel ?

  1. Right-click the cell where you want to comment.
  2. Click the Insert Comment button. Screenshot (138).png
  3. Where the cursor is blinking, type your comment. Screenshot (140).png
  4. Text will automatically wrap. Using the Enter key, you may start a new line. Screenshot (141).png
  5. Click outside the comment box when you're done.

How to quickly see all the comments ?

Use the shortcut (ALT+R+A2)to quickly see all of the comments. Screenshot (142).png

Formatting Comments

For all or part of an Excel comment, you may alter the typeface, font size, font colour, and font style.

  1. Right-click the cell in which the comment appears. Screenshot (145).png
  2. Select Edit Comment from the drop-down menu.
  3. Click on the comment shape's border to format all content.
  4. Drag over particular text inside the remark to select it and format it. Screenshot (146).png
  5. To change the look of the text, use the Font tools on the Formatting toolbar.
  6. Click outside the comment box when you're finished. Screenshot (148).png

Printing Comments

Excel comments can be printed in two ways:

  1. Print comments in the same order as they appear on the worksheet; Screenshot (141).png
  2. Print comments at the conclusion of the worksheet. Follow these procedures to print Excel comments at the conclusion of the worksheet:
    1. Select File|Page Layout | Page Setup
    2. Select 'At end of sheet' from the Comments dropdown on the Sheet tab.
    3. Select OK. Screenshot (143).png
    4. Select File|Print from the File menu (or click the Print button) Screenshot (144).png

Acknowledgement

This blog simply represents my own ideas and opinions (based on my limited knowledge) and should not be used as a replacement for legitimate sources. I'd welcome corrections in the comments if I ever make a mistake or if you disagree!

End note

These were the things that I was able to explore today, and I am looking forward to doing additional hands-on learning tomorrow. If you have any further information on the aforementioned concepts, please share it in the comments section below. Don't forget to connect me on Twitter and Github.

Have a great time !