Microsoft Office Tutorials and References
In Depth Information
If the contents of a worksheet will take up more than one printed page, you can have
Excel repeat one or more rows at the top of the page or columns at the left of the page.
For example, if you want to print a lengthy worksheet containing the mailing addresses
of customers signed up to receive your company’s monthly newsletter, you could repeat
the column headings Name, Address, City, and so forth at the top of the page. To repeat
rows at the top of each printed page, on the Page Layout tab, in the Page Setup group,
click Print Titles. Excel will display the Sheet page of the Page Setup dialog box.
On the Sheet page of the Page Setup dialog box, you can use the commands in the
Print Titles area to select the rows or columns to repeat. To choose rows to repeat at
the top of the page, click the Collapse Dialog button next to the Rows To Repeat At
Top box, select the rows, and then click the Expand Dialog button. The rows you
selected appear in the Rows To Repeat At Top box.
Similarly, to have a set of columns appear at the left of every printed page, click the Collapse
Dialog button next to the Columns To Repeat At Left box, select the columns, and then
click the Expand Dialog button. When you’re done, click OK to accept the settings.
In this exercise, you’ll select certain pages of a worksheet to print, have Excel it your
printed worksheet on a set number of pages, define a multi-region print area, center
the printed material on the page, and repeat columns at the left edge of each printed page.