excel 2013 print preview is not available

Now when you go to print, only the print area that you specified will appear on the printed page, or in any of the view modes that involve printing, like Page Layout view or the Print Break Preview view.įamiliarizing yourself with print areas is a useful tool to have, as it can be the source of a lot of problems when the print area prints only a small part of the worksheet. You can create a print area in Excel by selecting the cells that you want to print, clicking the Page Layout tab at the top of the window, then clicking the Print Area button and choosing the Set Print Area option. It will not affect workbooks that you have already created, or ones that are sent to you by other people.Īnother way to control the data that prints in your spreadsheet is a print area. If you make this change then all future new workbooks that you create will use this default view. You can find this by going to File > Options to open the Excel Options window, then click the Default view for new sheets dropdown menu and select Print Layout View.

Microsoft Excel also provides a way for you to set the default worksheet view. 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. Working with data in Microsoft Excel can have an extra element of difficulty when printing is involved.

Excel 2013 print preview is not available