Our guide below will show you how to switch to that view from whatever view is currently set in your workbook. One way to do this is with the help of the Page Layout view in Excel 2013.Įxcel 2013 has several different view options that you will find to be effective in certain situations, but the Page Layout option is particularly useful when you are concerned about correctly fitting your rows and columns to the printed page. There are a few easy ways to force your Excel 2013 spreadsheet to fit on one page, which can help to solve many of the print problems that you might be having with your worksheets.īut many Excel jobs don’t fit into the same set of criteria or only some of your spreadsheet might be printing, so you may find yourself needing to see the current print layout of your data so that you can adjust it manually. You can switch to Print View in Microsoft Excel 2013 by going to the View tab, then clicking the Page Layout option in the ribbon. Often it can make things a bit easier when you can see how the worksheet will look when it prints. In the Preview window, click Margins.Working with data in Microsoft Excel can have an extra element of difficulty when printing is involved.From the File menu, select Print Preview.Check Show margins, and then drag the margins to the desired size.In the upper left, click the Office Button.On the Page Layout tab, click Margins, and then.

Click Print Area, and choose Set Print Area.

Highlight the area of your spreadsheet that you want to print.

Use the arrows to increase or decrease the margin sizes, or enter.

On the Page Layout tab, click Margins, and then select.

Margins., adjust the values for each margin that you want Choose a different pre-set option, or select Custom.Under 'Settings', select the Normal Margins drop-down menu.To adjust the page margins on a printed spreadsheet in Excel, you can use Information here may no longer be accurate, and links may no longer be available or reliable. This content has been archived, and is no longer maintained by Indiana University.

Microsoft excel 2013 print preview