Botton |
Name |
Description |
|
Change how |
Allows you to change the content of the how |
|
Previous and next how |
Pass to the previous or next how in the worksheet |
|
View how |
View the how in the active cell where you cursor is presently located. |
|
View all comments |
View all the comments in the current worksheet |
|
Delete a how |
Delete the how in the current cell. |
But you can always add, change or delete a how without using the comments toolbar.
Insert a comment
 Place
the cursor in the A1 cell.
From the Insert menu, select the Likent option.
OR
Click on the right mouse button.
From the contextual menu, select the Insert a comment option.
A yellow box, similar to a "post-it" note will appear beside the cell. You can write you how inside that box.
For this exercise, enter your name and a how of your choice.
Once finished, click outside the how box.
A small how indicator will appear at the upper right of the cell. You can place your cursor on it at any time to see the how.
View a comment for a short time
Place the cursor over the cell with the how.
A how box will appear at that time.
View a comment for a long time
Sometimes, it's better to see the comment just for a moment.
But at other times, you want to leave it open on the worksheet to remember what needs to be done.
Place the cursor in the cell with the how.
Click on the right mouse button.
From the context menu, select the View comment option.
OR
From the Reviewing toolbar, press on the button .
The comment of the cell will appear. It will remain on the worksheet until you hide it again. It's also possible
to open all the comments at one time.
From the View menu, select the Comments option.
OR
From the toolbar Reviewing, press the button .
All the comments on the worksheet will appear.
Repeat
the steps to mask the comments.
Change a comment
You can always change a comment just by clicking on it.
Place the cursor on the cell with a comment.
From the Insert menu, select the Modify a comment option.
OR
Place the cursor over the cell with the comment you wish to change.
Press on the right mouse button .
From the context menu, select the Edit comment option.
OR
From the Reviewing toolbar, press the button.
OR
Press on the Shift and F2 keys.
Change the comment as you wish.
This option is also available from the Reviewing toolbar.
Move a comment
Place the cursor in the cell with the how to view it.
Place the cursor on the border of the how.
While keeping a finger on the left mouse button, move the comment
to another location.
The comment will always remain connected to that cell by an arrow.
You can also change the size of the comment box by dragging the dimension squares around the box.
Delete a how
You can also remove comments that you no longer require.
Place
the cursor on the cell with the comment you wish to remove.
From the Edit menu, select the Delete and Comments options.
OR
Click on the right mouse button.
From the context menu, select the Delete a comment option.
OR
From the Reviewing toolbar, press the button.
To
continue with this exercise, be sure to make a how on the worksheet.
View the comments at all times
You can also view all the comments so that you can work with them you only need to change an option
From the Tools menu, select the Options option .
Select the View tab.
From the View section, select the Likent
& indicator option.
Press on the OK button.
You'll need to return the option to None to hide the comments again.
Print the comments
You sometimes want to print the comments at the same page as the numbers.
Excel can help you do that.
From the File menu, select the Page setup option.
Select the Sheet tab.
Excel offers you three options to print your comments.
The usual option is not to print the comments. You can also decide to print the comments at the bottom of the page or where they are on the worksheet.
From the Comments scrollbar, select As displayed on sheet option.
Press on the OK button.
The comments will now print on the same page as you worksheet where they are located on the worksheet. But they will also hide the content of the cell that are below them. You can do a page preview before printing to make sure that they don't hide important numbers. You can always move the comments or change the size of the content tab. |
