The New Page Layout View in Excel

Question

How to see the New Page Layout View in Excel?

Answer

  1. Column headings
  2. Row headings
  3. Margin rulers

To see the new view, click Page Layout View on the bar on the bottom of the screen, it is on the right of the window. Or click the View tool to 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 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 view, you don't need to print preview to make adjustments to your worksheet before you print.

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.
 

For more information about Microsoft Excel Basics, please view the full tutorial from the CTL here: Excel Part 1

If you need further assistance, please click the CTL Support Request button on this page.

CTL Support Request Print Article

Related Services / Offerings (1)

CTL Support Request
The Center for Teaching & Learning develops and supports a diverse and inclusive community dedicated to excellent teaching, learning, and student educational experience regardless of location, formality, or modality.