Skip to main content
Workforce LibreTexts

17.1: Page Layout Tab

  • Page ID
    13693
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)

    clipboard_ec5b328c3df3ca531e2e18c8feec70951.png

    Page Layout Tab

    The Page Layout Tab allows the user to control the visual appearance of the worksheet when it is printed. The Page Layout Tab consists of five major groups: Themes, Page Setup, Scale to Fit, Sheet Options, and Arrange.

    Themes Group

    clipboard_e8524be425dc2f2285549e5cba77eb710.pngclipboard_ee1ee3b2da9b7124377bf26cfd386323a.png

    Microsoft Excel provides a variety of themes- fonts, colors, and backgrounds that go together to make Excel very customizable and visually appealing to the viewer. If none of the stock Excel themes interest the user, they can always make their own theme by customizing the Colors, Fonts, and Effect icons to the left of the Themes Icon clipboard_e6ef897532bfe09f6727d9b4b3c48c1f6.png.

    Page Setup Group

    Users can select the Margins icon if they wish to print their worksheets. Margins allow the user to specify how close to the top, bottom, left, and right of the printed page cell information is placed. Narrower margins allow more information to be placed on a printed page, wider margins will contain less information. The Orientation icon allows the user to determine whether the worksheet is created in a portrait or landscape view. Portrait orientations are best suited when a worksheet contains many rows of data, as the orientation provides more vertical room. Landscape orientation is best when a document has more column views.

    clipboard_e770c51f91b8f0192b79a358507ad279c.png

    The Size icon allows the user to set up their worksheet page height and width relative to the paper size they wish to print in Excel. For example, if the user selects Tabloid, Excel will allow more room in a worksheet to match the print area of the larger document (11” X17”). If a user would like to create a custom area on their excel document that they would like to print, for example- they have created charts that correspond to a table, but they only want to print the charts from a worksheet, they can select the cells they would like to print and then select the Print Area icon. They can also remove the print area by selecting the same icon and then clicking on Clear Print Area. Excel Users may also create custom page breaks and separate sections of their worksheet by selecting the Breaks icon. After selecting the cell where they wish to be the top right corner of the second page, they should click on the Breaks icon clipboard_ec6dd5d024b2f433edd8e646efaa7974a.png If a user wishes to remove the Page Breaks, they can select the Breaks icon again and click on Remove Page Break. A user may also insert a background image into their worksheet by selecting the Background Icon clipboard_e93a3f028ad2f34366677575e8285d11f.png. When selected, Excel will allow a user to find an image online using Bing Search, search their OneDrive Account for a picture, or find a picture on their computer.

    clipboard_e8660cfdb1a62e4516a0bf44a47cf1ebc.png

    Once an image is inserted, the icon changes to Delete Background clipboard_e26f9d372f2095a73a2d87bcd3ed9e31c.png, allowing the user to delete the image from their worksheet. Finally, Print Tiles clipboard_ef86fe4affceb4bba09680445e2869ea7.png provides the user with many options to best display your worksheet on a printed page. When selected, Print Tiles will launch the Excel Page Setup menu, which allows the user to select the Print Area, Rows to repeat at the top of each page, columns to repeat on each page on the left, and whether to print Gridlines, Comments, Row and Column Headings, and the order or the worksheet will print.

    clipboard_ec976f8c861bbf9666fccf2ddbb27558d.png

    Using the Page Setup menu, users can also adjust the Header/Footer text, the Margins, and the Page Settings, which provide a number of formatting changes that have already been discussed. On the Page tab, a few help options for printing are the Fit to settings which allow the user to specify how many total pages should be printed for their worksheet. A commons choice is to fit 1 page.

    clipboard_e38cc3e0202e9d2c72e2580a7bc230cde.png

    Scale to Fit Group

    clipboard_e976fb6a7728b953be327e9d399fc885c.png

    The Scale to Fit group provides similar controls to the Page Setup menu. Users may determine the page width and height to specify how many pages in a worksheet to print, depending on the settings selected for Width and Height, the Scale percentage box will adjust. Selecting the more options arrow, clipboard_e4f4aea7140e3e87a8d9333ac3e8576fb.png will launch the Page Setup menu again.

    Sheet Options Group

    clipboard_ec84d4cd7f20d7a34ee37ecb266dff4ed.png

    The Sheet Options group allows the user to control whether they can view gridlines and headings in their worksheet on their computer screen and/or on the printed page. The Arrange icon is used to manipulate images to allow them to be aligned with cells or appear on top of or behind other cell information. Objects can also be rotated and placed in groups.

    clipboard_e7e3e146b66bfb21401fd8b77ad93f615.png


    17.1: Page Layout Tab is shared under a CC BY license and was authored, remixed, and/or curated by Nick Heisserer.

    • Was this article helpful?