Printing Cell Comments
Some
cells contain data or formulas that require an explanation or special
attention. Comments provide a way to attach this type of information to
individual cells. A red triangle in the upper-right corner of the cell
indicates that a comment is present.
This task shows you how to
print your worksheets so that the printouts include the information in
your comments, either as they appear in the worksheet or at the end of
the worksheet.
1. Go to the Print pane in the Backstage View and click the Page Setup link.
2. On the Sheet tab, click the Comments field down arrow and choose either At End of Sheet, to print the comments, As Displayed on Sheet, or (None).
3. Click OK.
4.
View your worksheet in Print Preview mode to review the comments as
displayed in your worksheet (as in this example) or at the end of your
worksheet.
Note: As Displayed on Sheet
You
must have your comments “showing” in your worksheet (choose View,
Comments) for them to display when the As Displayed on Sheet Option is
selected. If they aren’t showing, they won’t display in the printout or
in Print Preview. |
Printing Cell Error Indicators
When
you print worksheets for friends or colleagues (or even yourself),
calculation errors that appear on your worksheet can create a negative
impression, which is why they’re not printed by default. If you want
these errors to be visible in your printout, however, you can display
them or replace them with any of the following: <blank>, --, or
#N/A.
1. Go to the Print pane in the Backstage View and click the Page Setup link.
2.
On the Sheet tab, click the down arrow next to the Cell errors as field
and choose displayed, <blank>, --, or #N/A depending on how you
want errors to be displayed.
3. Click OK.
4. View your worksheet in Print Preview mode to review how cells containing errors display.
Printing Repeating Row and Column Titles
You
might have noticed that when a worksheet spans multiple pages, it is
difficult to keep the column and row titles organized. A quick way to
rectify this is to make particular titles repeat on each page of the
printed worksheet.
1. Go to the Page Layout tab and click the Page Setup dialog launcher.
2. Click the Rows to repeat at top
selection box in the Print titles area. Excel shrinks the Page Setup
dialog box, making your focus the worksheet on your desktop.
3. Click the row containing the titles that you want to repeat on each page of your worksheet, and press Enter to reopen the Page Setup dialog box with your selection inserted.
4. Click OK.
If you want, view the worksheet in Print Preview mode to get an idea of
what your printed worksheet will look like with repeating row headings.
Note: Repeating Column Headings
To
repeat column headings across several pages, follow the steps in this
task, but click the Columns to repeat at the left selection box in step
2. Then, click the columns you want to repeat, and proceed as normal. |
