How to Switch to Page Layout View in Excel 2010

When you are working on a spreadsheet in Microsoft Excel 2010, the focus is usually on the data that you are adding, and the information that you are trying to find.

But if you are creating a spreadsheet that you need to print and share with colleagues, then you also need to be aware of how the spreadsheet will look on paper.

Fortunately, Excel 2010 has a special view, called “Page Layout”, that you can use which will show the layout of your data on the printed page.

This allows you to make adjustments to row and column sizes so that everything fits on the page as best as possible. Out tutorial below will show you how to switch to the Page Layout view.

View the Page Layout of Your Spreadsheet in Excel 2010

There are several different views in Microsoft Excel 2010. The default view is called Normal, and is likely the view to which you are most accustomed.

If you find that the Page Layout view from the steps below does not meet your needs, then you can also select from any of the other options available in Step 3.

Step 1: Open your workbook in Excel 2010.

Step 2: Click the View tab at the top of the window.

click the view tab

Step 3: Click the Page Layout button in the Workbook Views section of the Office ribbon.

click the page layout button

You should now be able to view your Excel worksheet as it will be printed.

sample page layout mode

This can be very helpful when you have a multi-page spreadsheet and are worried that some data will be separated on its’ own page. You can also read this article to learn about some helpful settings that you can adjust in Excel 2010 to make your spreadsheets look better when they are printed.

Now that you know how to switch to page layout view in Excel 2010, you can see how your spreadsheet will look when you print it out.

If you find that the page breaks in your spreadsheet do not make sense, then they may have been manually inserted. This article will show you how to remove all of the page breaks from an Excel 2010 worksheet.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy