kwret.blogg.se - Problem excel 2013 print preview show margins

Problem excel 2013 print preview show margins how to#
Problem excel 2013 print preview show margins update#

To deal with this we can make use of the Custom Scaling Option. For example if you use the fit to one page wide and all the text becomes unreadable what then? Well clearly your worksheet needs to be printed over more than one page wide but it only need to be two pages wide instead of the three it may currently be. The quick scaling options work in a many cases but they are not always suitable. Useful when you have a multi-page printing worksheet that you need to fit (see below). Fit All Rows on One Page - The printed height is adjusted to accomodate all the rows in your worksheet.Fit All Columns on One Page - The printed width is reduced to accomodate all the columns in your worksheet.Fit Sheet on One Page - Useful if you have something that will reduce slightly and so fit on one page.No Scaling - The worksheet will print exactly as it is set.

Problem excel 2013 print preview show margins update#

The Print Preview will update to show you the affect and the number of pages that will now be needed.

From the Scaling options, click "Fit All Columns on One Page" (2).

At the bottom of the Settings area, click the "No Scaling" button (1).

You are now given a preview of your printed worksheet.The most common requirement is to be able to fit all the columns on one page wide and we do this as follows: This allows Excel to print a worksheet that either fits entirely on one page, or has all the columns fit on one page wide, or has all the rows fit on one page tall or some other dimensions we choose. Page Scaling is a feature of Excel that magnifies or shrinks the printed worksheet image as required.

Note the buttons in the bottom right of the Print Preview area (3) - these can be useful later on.

you have one set of pages printing with one column).

Using the vertical scroll bar (1) or the page navigation buttons (2), check how it will print to see and whether you need to make some adjustments (e.g.

You are now given the print options as well as a preview of your printed worksheet.

Print Preview BEFORE printingīefore printing your worksheet and only then discovering you have a sheaf of pages with just one column on, always use the Print Preview feature to see how the worksheet will print - not only will this save you time but also a large chunk of paper. Note, the guidance that follows assumes you are using Microsoft Excel 2010 - don't worry if you are using a different version - the principles are the same across all versions of Excel and any particular differences will be highlighted and explained.

Adjust Columns - If you need to keep the print as large as possible, adjusting the columns will be appropriate but this does a bit of time to get perfect.

Print Area - Limit the area being printed is another way to get the printed worksheet to fit.

Adjust margins - A minor adjustment to the margins can often fix a short "over-run".

Page Scaling - Excel can magnify or shrink the printed image to fit the page numbers required.

Use bigger paper! - A simple solution but let's face it wrestling with A3 pages is hard work.

Change the page orientation - Obvious when someone else points it out.

Don't print it! Do you really really need to print it, if so carry on.

Whilst the first technique we are going to show you deals with most needs however there are various other techniques that can be used as no one way which is appropriate in all cases.

Problem excel 2013 print preview show margins how to#

So here we show you how to print a spreadsheet to fit a set number of pages. You may get a whole other set of pages printing with just one column and other times a few rows on the last page. For more about page margins, see Set page margins before printing a worksheet.One of the most common queries we get about Microsoft Excel is printing a worksheet and having it fit on a certain number of pages. You can also change the column widths by dragging the handles at the top or bottom of the print preview page.

To change margins, drag the margins to the height and width that you prefer. To view page margins, click the Show Margins button in the lower right corner of the Print Preview window. To exit Print Preview and return to your workbook, click any the arrow in the upper-left of the Print Preview window. To preview the next and previous pages, click the arrows for Next Page and Previous Page at the bottom of the Print Preview window-or type the page number. To view multiple worksheets, under Settings, click Entire workbook. Next Page and Previous Page are available only when you select more than one sheet, or when a sheet contains more than one page of data. Unless you're using a color printer, the preview will appear in black-and-white, even if there is color in your sheet(s).