All commands (icons) that deal with comments are found in the Review tab, Comments group.
To insert a new comment:
1. Select the cell where you want to insert the comment.
2. Click New Comment.
3. A new comment will be created. Type the required text then click outside the comment box.
4. The comment box will disappear but a small indicator will show [...]
To print comments in Excel 2007:
1. Show all comments or just the comments you want to print. How?
2. In the Page Layout tab, Page Setup group, click the dialog box launcher (see the mouse pointer in the image below).
3. The Page Setup window will open.
4. Click on the Sheet tab.
5. In the Comments box, select As displayed on sheet or [...]
If you have a worksheet with a heading row at the top, then you may want to freeze the heading row while scrolling throw the data rows below it. To achieve that follow these simple steps.
1. In the View tab, Window group click Freeze Panes.
2. From the drop down list select Freeze Top Row.
3. A dark line will [...]
If you have a large worksheet, then you may want to freeze the worksheet at one point while scrolling throw the rest of the rows below it. To achieve that follow these steps.
1. Select the top row of the area which you want to be scrollable (or just a cell in that row). I.e. all rows [...]
To average cells based on multiple criteria in Excel 2007 you use the AVERAGEIFS function.
Syntax
AVERAGEIFS(average_range,criteria_range1,criteria1,criteria_range2,criteria2…)
Average_range is the range of cells to average, including numbers or names, arrays, or references that contain numbers.
Criteria_range1, criteria_range2, … are 1 to 127 ranges in which to evaluate the associated criteria.
Criteria1, criteria2, … [...]
