One way to include your documentation without cluttering up the worksheet is to use comments.
Excel lets you insert into any cell a comment that acts like a hidden sticky note.
By default, a cell that has a comment displays a small red triangle in the upper right of the cell.
Move your mouse over cell A1 in the illustration.
The comment pops into view. When you move the mouse out of the cell, the comment vanishes again.
Most comments are hidden until you select or hover over the cell. The Status bar changes to show that the selected cell has a comment.
Location: pops up at the right of the cell with its top a little higher than the top of the cell.
Not your name: If your name is not showing as the comment's author, you can delete the name and retype. If you expect to do a number of comments and you are working in your own copy of Excel(!), change the user name in Excel Options > General. Then you won't have to retype each one. This change will be picked up by ALL Office programs, so be careful.
Formatting for comment: The background color is the color set for the background of all ToolTips. A ToolTip is the little popup tip you see when your mouse hovers over a button or other feature. Control Panel > All Control Panel Items > Personalization >Window Color and Appearance > Advanced appearance settings > change drop box for Item: to ToolTip to see the default settings. Even though this dialog show the font as Segoe UI, the default font will be Tahoma for your comments.
You can format the text inside your comment box with all the normal tools as you create it.
Once you have created a comment, you can make changes when you are in Edit mode.
Method 1: Select the cell and on the Review ribbon tab in the Comments tab group, click on the button Edit Comment.
Method 2: Right click the cell and choose Edit Comment from the context menu.
Name box shows the cell reference for the cell to which the comment is attached.
Border of the comment shows diagonals.
Cursor is in the comment and blinks.
Excel remembers the position for editing: If you need to see underneath a comment while you are editing, just drag the comment by its border. The next time the comment pops up, it will be back in the default location - to the right of the cell with the comment's top edge slightly above the cell. When you next edit the comment, however, it will move to where you left it the last time you edited. A bit confusing... but actually handy!
You can format your comment text box only when the box is selected. The comment box is actually an AutoShape. Click on the border of the comment text box to select it. If you miss and click outside of the border, the comment will close. If you miss and click inside of the border, you will be in Edit mode for the text.
Name Box shows the comment's number.
(Comments are numbered in the order in which they are created.)
Border of the comment shows dots instead of diagonals.
No cursor in the comment box.
Change Shape of Comment: A comment can use any AutoShape but the Drawing Tools ribbon tab does not show up when a comment is select. You need the command Edit Shape. You can put it on the Quick Access Toolbar or, in Excel 2010, you can add it to a new ribbon tab or a new tab group.
|What you will learn:||to create a comment
to format a comment - fill and font color
to edit an existing comment
to use keyboard shortcut in a comment
to add a command to the Quick Access Toolbar
to change the shape of a comment
Start with: trips30-Firstname-Lastname.xlsx - sheet Specials (saved in previous lesson)
Comments about the sheet as a whole are usually put in cell A1. However, for some sheets, such a comment could not be visible all the time without blocking part of the sheet.
Below the user name, type Created on and type the date, a space, and then the word for , a space, and then the name of the class you are doing this sheet for.
You can't use Insert > Date like you can in the Header/Footer. If you are not sure of the date, hover over the time in the Windows tray at the bottom right of your screen. The date will popup if it is not already showing.
The Review tab has a Comments tab group for managing your comments. You can also right click on a cell with a comment to get a few of these commands.
click on cell G1.
The context menu appears. Since this cell already has a comment attached, the choices are different than before.
Notice that this menu also includes Delete
Comment and Show/Hide Comment.
On the Review tab there is a button to show or hide all comments on the
Right click on the selected comment and from the context menu, select Format Comment.
The Format Comment dialog appears, with several tabs.
Dialog has only one tab
You missed the border with your right click and click inside the comment. You opened the dialog to format the text inside the comment.
Solution: Close the dialog and right click the border of the dialog.
You missed with your right click and clicked outside the comment.
Solution: Just repeat the steps above to open the comment up and try again.
the Colors and Lines tab, set the Fill Color to Aqua and the Transparency to 50%.
Leave the line color as Black.
The transparency lightens the color and lets the grid lines or whatever is underneath show through. This can be helpful for comments that pop up over data cells.
colors: Did you notice the colors? The palette of colors is not
using the new Theme colors. It's showing the old color palette.
This makes it very difficult to match the colors to other colors on
Next you will add some text to the existing comment.
You can change the plain rectangle shape for a comment but it's not as easy as in earlier versions of Excel. The Drawing Tools tab does not appear when you select the comment even though the comment is a text box shape.
You will add a command to the Quick Access Toolbar. In Excel 2010 you have an additional option. You can add the command to a custom ribbon tab or to an existing tab (like the Review tab) in a custom tab group.
Click on the More button at the right end of the Quick
A menu appears. The first items are commands that many users want to see on the Quick Access Toolbar. A check mark means that item is already on the bar.
shows a bar with some additional items that are not on the quick
Click the Up arrow to the right of the list to move Edit Shape up one spot.
Alternate Method: First
select the toolbar item in the list on the right that you want your
new item to follow. Then click the Add>> button.
Now you can get to the various shapes and play around.
There is no Live Preview when you hover over a shape in the palette.
Click an interesting shape. Does your text fit? Can you resize the shape so that the text does fit nicely?
Try out other shapes.
Some shapes do not work well with the transparency, like 'rounded rectangle' on the first row of shapes and all of the shapes on the second row. The fill color becomes quite dark and the lighter color shows only as part of the 3D effect. Of course you could change the font color to a light color if you really wanted the shape.
When you are ready to continue...