MS Excel 2007 - Lesson 13: Format Sheets and Prints: Microsoft Excel

Understanding Microsoft Excel requires more than a headline. The overview below breaks down the key facts, changes, and user impact.

Microsoft Excel Overview

TipsMake. Com - Set up printing labels

This section explains the key facts, background, and practical implications of MS Excel 2007 - Lesson 13: Format Sheets and Prints: Microsoft Excel. To set up Print Titles:

• Click the Page Layout tab on the Ribbon

• Click the Print Titles button

• In the Print Titles section, click the box to select the row or column to be repeated

• Select the row or column

• Click the Select Row / Column button

• Click OK

Create Header and Footer

To create a header or footer:

• Click the Header & Footer button on the Insert tab

• Now, the Design tab for Header & Footer will appear on the Ribbon

• To switch between Header and Footer, click the Go to Header or Go to Footer button

• To insert text: enter text into the header or footer

• To enter pre-programmed data such as page number, date, time, file name or sheet name. Click the appropriate icon

• To change the location of the data, click to select the cell you want

Page margins set

To set page margins:

• Click the Margins button on the Page Layout tab

• Choose one of the options offered, or

• Click Custom Margins

• Complete the page margin setting dialog

• Click OK.

Change page orientation

To change the page orientation from vertical to horizontal:

• Click the Orientation button on the Page Layout tab

• Choose Portrait or Landscape (horizontal)

Set page breaks

You can set page breaks in a spreadsheet to read sheets easily when printing. To set up page breaks:

• Click the Breaks button on the Page Layout tab

• Click Insert Page Break

Print a region

You may want to print only part of a spreadsheet. This work is done easily through the Print Range function. To print a region:

• Select the printed area

• Click the Print Area button on the Page Layout tab

• Click Set Print Area.