The Page Layout Tab of Excel 2007

The Page Layout Tab of Excel 2007

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.

Page Layout Tab Excel 2007

Page Layout Tab Excel 2007
Page Layout Tab Excel 2007 | Source

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 for the current 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 different built in effects that can be used for instance metro, office, urban, apex, among others.

The Page Setup Group

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.

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 | Source

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.

Are you able to switch pages between portrait and landscape layouts

  • Yes
  • No
See results without voting

© 2013 Patrick Kamau

More by this Author


Comments 4 comments

Patkay profile image

Patkay 3 years ago from Nairobi, Kenya Author

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


lucy patrick 3 years ago

good work patkay


Patkay profile image

Patkay 3 years ago from Nairobi, Kenya Author

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


torrilynn profile image

torrilynn 3 years ago

Hey Patkay,

very useful hub

thanks for the information

Voted up

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.


    Click to Rate This Article
    working