Updated date:

The Page Layout Tab of Excel 2007

Patrick, a computer technician, is a dedicated writer who wishes to make the world better by informing individuals who seek more knowledge.

How to Work With the Page Layout Tab of MS Excel

Excel 2007 adds a new view called Page Layout, which allows you to see how your worksheet will print and lets you add a header and/or footer. The commands and options that you will find under the Page Layout tab will allow you to adjust how your document will look on paper. The page layout tab of Excel 2007 is mostly used for page setting options. For instance, there are commands that you are going to use for setting margins, orientation, and setting size of the page. It is divided into five groups that are discussed here in details. This article will help you understand these options and use them to present your document in the best possible way.

Page Layout Tab Excel 2007

Page Layout Tab Excel 2007

Page Layout Tab Excel 2007

Themes Group

Themes – you can use this command to change the overall design of the entire document, including colours, fonts, and effects. Pointing at the theme button, you will be able to see the current theme you are using. Clicking on the drop-down button, you will be able to change it by selecting the theme you want among the list of themes provided.

Colours – this tool will change the colours of the currently selected theme.

Fonts – this command will change the fonts for the theme you are currently using.

Effects – this will change the effects for the current theme in use. There are differently built-in effects that can be used for instance metro, office, urban, apex, among others.

The Page Setup Option

Margins – the page setup group starts with the margins command which is used to set the margin sizes for the entire document or the current section of the document you are preparing.

Orientation – this command is for setting the orientation of the document. It will be used to switch pages between portrait and landscape layouts.

Size – this tool is for choosing the paper size for the current section of the document you are working on.

Print Area – this is a very useful command for marking a specific area for printing. It will also be used for clearing the print area.

Breaks – this specifies where a new page will begin in the printed copy. Page breaks are inserted above and to the left of the section.

Background – this command will help you choose an image to be used as the background of the sheet.

Print Titles – this command specifies rows and columns to repeat on each printed page.

The Scale to Fit Group

Width – using this command will shrink the width of printed output to fit a maximum number of pages.

Height – this shrinks the height of the printed output to fit a maximum number of pages.

Scale – this command shrinks or stretches the printed output to a certain percentage of its actual size. To use this feature, set the maximum height and width to automatic.

The Sheet Options Group

Gridlines (view) – you can opt to show or not to show the lines between rows and columns in the sheet to make editing and reading easier.

Gridlines (print) – this command will print the lines between rows and columns in the sheet to make reading easier.

Headings (view) – this command will show row and column headings. Row headings are the row numbers to the side of the sheet while column headings are the letters that appear above the columns on a sheet.

Headings (print) – this command will print row and column headings on your printed work.

The sheet options and arrange group

The sheet options and arrange group

The Arrange Group

Bring To Front – this command is used with objects. It brings an object in front of all the other objects such that no part of it is hidden by the others.

Send To Back – this command sends a selected object behind all other objects.

Selection Pane – this command is for showing the selection pane which will help you select individual objects and to change their order and visibility.

Align – this is for aligning the edges of multiple selected objects. You can also center them or distribute them evenly across the page.

Group – use this tool to group objects together so that they can be treated as a single object.

Rotate – this rotates or flips the selected object.

Excel 2007 Overview Guide

© 2013 Patrick Kamau

Comments

Patrick Kamau (author) from Nairobi, Kenya on April 12, 2013:

lucy patrick, thanks for reading and approving my work. I am glad you liked it.

lucy patrick on April 11, 2013:

good work patkay

Patrick Kamau (author) from Nairobi, Kenya on March 12, 2013:

torrilynn, thanks for reading and commenting. I am glad that you liked the hub. Thank you reading and the vote.

torrilynn on March 11, 2013:

Hey Patkay,

very useful hub

thanks for the information

Voted up