Page 8 of 27PREVNEXT

Up to speed with Excel 2007

Page Layout view

The new Page Layout view in Excel.
Callout 1 Column headings.
Callout 2 Row headings.
Callout 3 Margin rulers.

Not only the Ribbon is new in Excel 2007. Page Layout view is new too. If you have worked in Print Layout view in Microsoft Office Word, you'll be glad to see Excel with similar advantages.

To see the new view, click Page Layout View on the View toolbar View toolbar on the bottom right of the window. Or click the View tab on the Ribbon, and then click Page Layout View in the Workbook Views group.

In Page Layout view there are page margins at the top, sides, and bottom of the worksheet, and a bit of blue space between worksheets. Rulers at the top and side help you adjust margins. You can turn the rulers on and off as you need them (click Ruler in the Show/Hide group on the View tab).

With this new view, you don't need print preview to make adjustments to your worksheet before you print. You'll see more about that in the next lesson.

It's easy to add headers and footers in Page Layout view. When you type in the new header and footer area at the top or bottom of a page, the Design tab opens with all the commands you need to create your headers and footers. More about that too in the next lesson.

You can see each sheet in a workbook in the view that works best for that sheet. Just select a view on the View toolbar, or in the Workbook Views group on the View tab, for each worksheet. Normal view and Page Break preview are both there.

Tip     If you like Page Layout view, but you'd prefer a little less white space in the margins, you can hide some of that white space. We'll show you how in the practice at the end of the lesson.

Page 8 of 27PREVNEXT