ADJUSTING WORKSHEET LAYOUT AND DATA

ADJUSTING WORKSHEET LAYOUT AND DATA

Page Layout – Print Titles

Page Layout – 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. The Print Titles command allows you to select specific rows and columns to appear on each page.

Click the Page Layout tab on the Ribbon, then select the Print Titles command. 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.

Print Titles

Print Titles Click the Collapse Dialog button next to the Rows to repeat at top: field. 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. Row 1 will be added to the Rows to repeat at top: field. Click the Collapse Dialog button again.

The Page Setup dialog box will expand. Click OK. Row 1 will be printed at the top of every page.

Header & Footer

Header & Footer You can make your workbook easier to read and look more professional by including headers and footers. The header is a section of the workbook that appears in the top margin, while the footer appears in the bottom margin. Headers and footers generally contain information such as page number, date, and workbook name.

Locate and select the Page Layout view command at the bottom of the Excel window. The worksheet will appear in Page Layout view. Select the header or footer you want to modify. The Header & Footer Tools tab will appear on the Ribbon. From here, you can access commands that will automatically include page numbers, dates, and workbook names.

ADJUSTING WORKSHEET VIEWS

ADJUSTING WORKSHEET VIEWS

Freeze Panes

Freeze Panes To Freeze a column in Excel follow these easy steps: Select the column to the right of the column you wish to freeze. Click the View tab on the Ribbon. Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu. Your selection will be frozen in place.

Freeze Panes

Freeze Panes To Freeze a row in Excel follow these easy steps: Select the row below the row(s) you wish to freeze. Click the View tab on the Ribbon. Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu. Your selection will be frozen in place.

MULTIPLE WORKSHEETS AND WORKBOOKS

MULTIPLE WORKSHEETS AND WORKBOOKS