The “Page Layout” tab

The “Page Layout” tab is used to determine the representation of our document.
The “Page Layout tab” is divided into 5 different groups.
The first is “Themes”, which we had already seen in a previous lesson, so we can skip this.

The second group is “Page Setup”.
The first option in this group is “Margins”.
When we click on it, it opens a drop-down menu with various settings.
The top option is the default setting.
The second option is the “Orientation” and the default orientation is “Portrait”.
Click on the downward pointing arrow and choose “Landscape” to change this.
The third option is “Size”.
Default is set to “Letter” size.
When we click it, it opens a drop-down menu with several preset formats.
The fourth option “Print Area”, allows us to set a range that we want to print.
Select a range, click the “Print Area” button and select “Set Print Area”.
Click the “Print Preview” button which is in “Quick Access” menu.
If you want to remove the print area, click again on the “Print Area” button and select “Clear Print Area.”

If you wish to add a range, choose “Add to print area”.

With the fifth option “Breaks”, we can manually add or delete page breaks.
Place the cursor in the cell where you want to insert a page break, and click “Breaks”.
Select “Insert Page Break”.
To remove page breaks, repeat these steps but select “Remove Page Break.”

Click the button “Background” to use a picture as a background for our worksheet.
The photo that is used for our background is not printed.
To remove the picture from the background, click “Delete Background”.

The “Print Titles” button allows us to repeat certain rows or columns in print.
This is useful when our print goes into multiple pages. With this, our column titles or row titles gets printed on every page.
Click the “Print Titles” button and in the dialog box that appears, give the range of the column headings to be repeated in the second box.
Click the ‘Collapse’ button and select the row with column headings to be repeated.
Click the “Expand” button and click OK.

The third group in the “Page Layout” tab is “Scale to Fit”.
The options in this group allow us to set the “Width”,”Height”, or “Scale” on various pages.

The next group deals with various “Sheet Options”, all of which are quite clear.

In the last group “Arrange”, we can insert shapes, images, etc., align, rotate, group and organize.

Changing margins

To change margins to something other than the options in the menu, click the “Custom Margins …” option.
This opens up the “Margins” tab in the “Page Setup” dialog box.
Here you can set different margins for “Top”, “Left” “Right”, and “Bottom” and “Header”,”Footer”.
Enter greater values in the various boxes to enlarge the border around the data.
Click OK when all you are done.

You can optionally switch to display “Page Layout”, where you can further customize the margins, if necessary.

“Headers and footers”

Inserting “Headers and footers” is much easier in “Excel 2007”.
Just click the “Header and Footer” in the “Insert”tab in the “Ribbon”.
This automatically takes you to the “Page Layout” view.
The “Design” tab in the “Header and footer tools” is selected.

The header and footer areas are divided into three sections.
Left aligned, center aligned and right aligned.
You can enter data in each of these sections.
First, select the section, choose one or more elements for headers and footers, or type what you want to insert.

To quickly switch between header and footer, click the “GoTo Header” or “Go To Footer” buttons.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats