Page 84 - Ms Excel Note and Workbook

MICROSOFT EXCEL NOTE AND WORKBOOK

To include Print Titles:

If your worksheet uses title headings, it's important to include these headings on each page of your
printed worksheet. It would be difficult to read a printed workbook if the title headings appeared
only on the first page.

1. Click the Page Layout tab on the Ribbon, then select the Print Titles command.

2. The Page Setup dialog box will appear. From here, you can choose rows or columns to
repeat on each page. In our example, we'll repeat a row first.

3. Click the Collapse Dialog button next to the Rows to repeat at top: field.

TIP
The Print Titles command
allows you to select
specific rows and columns
to appear on each page.

4. The cursor will become a small selection arrow, and the Page Setup dialog box will be
collapsed. Select the row(s) you want to repeat at the top of each printed page. In our
example, we'll select row 1.

75 | P a g e