• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Layouts in Excel

August 21, 2021 by Andrew Childress
Layouts in Excel

When you’re working in a spreadsheet, you may find yourself wanting to print the finished file. Let’s learn how to use layouts in Microsoft Excel.

When you’re working in a spreadsheet, you may find yourself wanting to print the finished file. Perhaps you want a vertical orientation, or a wider, landscape style. Fortunately, Excel makes it easy to choose either one. Let’s learn how to use layouts in Microsoft Excel.

How to Use Layouts in Excel

Printed pages take two basic forms. Vertically-oriented layouts are called portrait style. Wider, horizontal layouts are called landscape. Before making a choice for your spreadsheet design, it helps to consider the content you have on your sheet.

If you have many rows but few columns, portrait layouts fit the most data onto a single page. Wider, shorter datasets will naturally benefit from landscape designs. Whichever option you choose, Microsoft Excel makes it easy to apply.

Imagine that you want to change the layout of your Microsoft Excel spreadsheet. To get started, go to the Page Layout tab. You’ll find it on the Insert tab, located on Excel’s ribbon. This menu option gives you a variety of selections to change up the look and feel of your Excel spreadsheet.

To change the layout, find the Orientation dropdown menu. You’ll see two options appear: Portrait and Landscape.

Layouts in Excel

Click on either one to apply it to your sheet, based on how you want the printed version to be arranged.

You’ll see that Excel now shows a thin dotted line on your sheet. This is a visual guide telling you where the margins – or edge – of your printed page will be. In other words, anything across that dotted line will be shifted to a second page in your printout.

Print layouts in Excel

You can also verify your Excel layout design by going to File > Print. In the preview window, you’ll see the printed layout displayed.

Change layouts in Excel

As you can see, Excel makes it easy to change the layout of your spreadsheets.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Use add ins in ExcelAdd-ins in Excel
Next Post:Add Pictures in ExcelAdd images in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top