The Page Layout Ribbon in Excel 2007

The Page Layout Ribbon, the third of the Standard Ribbons, makes the page setup function more accessible. In the Classic version, the page setup function is accessed via the File Menu. In addition to the page setup function, the Ribbon has 2 more command groups which we will discussed later in this page.

Below is a screenshot of the Insert ribbon:

Themes

The command themes allows user to change the existing set of colors, font type, effects of the workbook to another. You could also amend any of the settings individually. In the classic version, these settings can also be changed through the Tools Menu -> Options.

Page Setup

If you have used page setup in the classic version before, this group of commands will not be unfamiliar to you. Most of the page setup options and settings are grouped together here. The only exceptions are the scale to fit function, the option to print gridlines and the row & columns labels. These are classified separately in the page layout ribbon.

screenshot page layout ribbon sheet option

Arrange

The arrange group of commands is used to arrange objects (pictures, shapes, text boxes, etc). For example, if you wish to align the pictures to the gridlines, all you have to do is to activate the option and all your objects will be snapped to the gridlines as you create or move them.

Lesson 01: Why learn Excel 2007?
Lesson 02: A new look for Excel 2007 and access the "file menu".
Lesson 03: No more toolbar in Excel 2007.
Lesson 04: What are on the Ribbons in Excel 2007.
Lesson 05: 7 Standard Ribbons in Excel 2007.
Lesson 06: Home Ribbon in Excel 2007.
Lesson 07: Insert Ribbon in Excel 2007.