ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

The Page Layout Tab of Excel 2007

Updated on August 25, 2018
Patkay profile image

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

The Page Layout Tab of Excel 2007

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

See results

Excel 2007 Overview Guide

© 2013 Patrick Kamau


    0 of 8192 characters used
    Post Comment
    • Patkay profile imageAUTHOR

      Patrick Kamau 

      7 years ago from Nairobi, Kenya

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

    • profile image

      lucy patrick 

      7 years ago

      good work patkay

    • Patkay profile imageAUTHOR

      Patrick Kamau 

      7 years ago from Nairobi, Kenya

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

    • torrilynn profile image


      7 years ago

      Hey Patkay,

      very useful hub

      thanks for the information

      Voted up


    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at:

    Show Details
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the or domains, for performance and efficiency reasons. (Privacy Policy)
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)
    ClickscoThis is a data management platform studying reader behavior (Privacy Policy)