Happy Computers Essentials Guide to

Adding Comments To Your Worksheet

You can add Comments to your worksheet to help understand what you have done! This is a hidden note that you can read when you want but which you wouldn't normally see or print.

Adding A Comment To A Cell

Select the cell that will contain the note

Insert Menu : Comment A “Comment box” appears, with the name of the person who has logged onto the machine.


Type in your note

Click OK The note will be added to your cell.
The only indication that it is there is the small red triangle in the top right corner of the cell. (See below)

Red Triangle Indicates A Comment

Reading Your Comment

Rest your mouse on the cell with the red triangle

Comment will pop-up

Deleting A Comment

Rest your mouse on the cell with the red triangle

Comment will pop-up

Click on the View menu

Select Toolbars

Select Reviewing A toolbar will appear

Select the Delete comment icon


You can use your Right Mouse Button here!!

• 
  Right click on the cell with the comment that you want to delete
  
• 
  Choose Delete Comment from the drop down menu
  

What do the icons mean?
New Comment
Previous Comment
Next Comment
Show Comment
Show All Comments
Delete Comment
Create Microsoft Outlook Task
Update File
Send Mail to recipient

Formatting A Comment

Rest your mouse on the cell with the red triangle

Comment will pop-up

Right click with your mouse

Select Edit Comment from the drop down menu

If you have a sound card in your computer, then you can record a sound note and embed that in a cell. When you double-click on the cell then the sound will play!

Displaying Comments All the Time

Click on the Tools Menu

Click on Options

Choose the View tab

Select the Comment and Indicator option

Click OK

Printing Comments

Complete the above steps to display comment all the time

Click on the File Menu and Choose Page Setup

Click on the fourth tab called sheet

Under the Comment Section and select “As displayed on sheet” or “At end of sheet”

Click OK

Adding A Post-It Type Comment

You can add a post-it type Comment that sticks on top of your spreadsheet.

Creating The Post-It Note

Click on the drawing toolbar icon

Click on the Text Box Icon

Click and drag a square on the spreadsheet for your post -it note

Click inside the note and type the note you want

Moving, Sizing and Deleting A Post-It Note

Click away from the Comment so that it is not selected

Click on the Comment to select it - it should look like the following

To move the note: click and drag on the border

To size the note: click and drag on one of the squares

To delete the note: press DELETE on the keyboard

Creating Range Names

Instead of referring to the parts of your worksheet with cell references you can give them names instead. This makes your worksheet easier to read and work with.

Giving A Cell or Range of Cells A Name

Select the cells to name (This can be a single cell or a range of cells)

Click into the name definition box

Type a name for the range and press return

You may think nothing has changed, but

when you select the all the cells, the range

name will appear in the definition box.

Using Spaces in Names

Excel doesn’t allow spaces in a range name. It is better to use an underscore ”_” instead.

Creating Names From A List

Select the cells to name and the cells that contain

the labels next to them

Insert Menu : Name : Create The dialog box will appear



Click OK

Deleting Range Names

Insert Menu: Name : Define

Select Range Name to delete

Click in Delete

Click on OK
Range Names and Absolute Cell References

When you create a range name it acts like an absolute cell reference. This means that when you copy a formula involving a range name it will always point to the same cell. Thus you cannot autofill a formula that contains a range name and get it to work on different columns of numbers.