Page 15 of 23PREVNEXT

So that's how! Printing options in Excel

Column titles repeated on multiple pages

You can print the column titles (months) and the row titles (company names) on every page. You can also print the alphabetical column headings and numerical row headings on every page.

When you enter data in a worksheet, it's a good idea to put a title at the top of each column and to the left of each row, so that everyone can understand what the data means.

When it's time to print, if you see in print preview that you have more than one page (and we hope that you do look before you print) it's important to print those titles on all the pages. You don't want readers flipping back to page 1 to look for column or row titles that identify data on page 2 or 3 (or 23).

How do you get entitled? You go to normal view, and on the File menu, you select Page Setup. In the Page Setup dialog box, click the Sheet tab and enter the row titles and column titles you want Excel to print on every page. You'll do this in the practice.

Print column and row headings

You can also choose to print on every page the letters and numbers that Excel uses to identify columns and rows. Then if you refer to the data in column E, row 42, people looking at the printout can find it fast.

To print these headings, you go to the Sheet tab in the Page Setup dialog box. Under Print, you select the Row and column headings checkbox.

Tip     Want to print titles and headings, both at once? You can: just follow both these procedures.

Page 15 of 23PREVNEXT