Microsoft Office Tutorials and References
In Depth Information
Getting Ready to Print a Worksheet
✦ Centering worksheet data on the page: On the Margins tab of the page
Setup dialog box, select Horizontally or Vertically to center the
worksheet relative to the top or bottom or sides of the page. You can select
both check boxes. The preview screen shows what your choices mean
in real terms.
✦ Printing gridlines, column letters, and row numbers: By default, the
gridlines, column letters, and row numbers that you know and love in a
worksheet aren’t printed, but you can print them by going to the Sheet
tab of the Page Setup dialog box and selecting the Gridlines check box
as well as the Row and Column Headings check box.
Repeating row and column headings on each page
If your worksheet is a big one that stretches beyond one page, you owe it
to the people who view your worksheet to repeat row and column headings
from page to page. Without these headings, no one can tell what the data in
the worksheet means. Follow these steps to repeat row and column
headings from page to page:
1. On the Page Layout tab, click the Print Titles button.
You see the Sheet tab of the Page Setup dialog box.
2. Select the Row and Column Headings check box.
You can find this check box under Print.
3. To repeat rows, click the Range Selector button next to the Rows to
Repeat at Top text box; to repeat columns, click the Range Selector
button next to the Columns to Repeat at Left text box.
These buttons are located on the right side of the dialog box. The dialog
box shrinks so that you can get a better look at your worksheet.