Printing Repeating Row and Column Titles

graphics/10inf13.jpg

graphics/one_icon.jpg

Open the File menu and select Page Setup; then select the Sheet tab on the Page Setup dialog box.

graphics/tow_icon.jpg

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.

graphics/three_icon.jpg

Select the row(s) containing the titles you want to repeat on each page of your worksheet; then press Enter to reopen the Page Setup dialog box with your selection.

graphics/foure_icon.jpg

Click OK. If you want, you can view the worksheet in Print Preview mode to get an idea of what your printed worksheet will look like with repeating row headings.

INTRODUCTION

You might have noticed that, when a worksheet spans multiple pages, keeping the column and row titles organized is difficult. A quick way to rectify this is to make particular titles repeat on each page of the printed worksheet. In this task, you'll learn how to make row headers repeat.

TIP

Repeating Titles in Print Preview Mode

You cannot assign repeating titles while you are in Print Preview mode; you must be in the worksheet view and select File, Page Setup.

TIP

Repeating Column Headings

To repeat column headings across several pages, follow the steps in this task, but click the Columns to Repeat at Left selection box in step 2. Then, click the columns you want to repeat and proceed as normal.



Easy Microsoft Office 2003
Easy Microsoft Office 2003
ISBN: 0789729628
EAN: 2147483647
Year: 2003
Pages: 281
Authors: Nancy Lewis

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net