Print One Sheet Excel

If you want to only print a certain part of your spreadsheet you ll need to adjust the print area.

Print one sheet excel. Let s take a look at the exercise file to see how this works. Print only certain worksheets in excel print only certain worksheets in active multiple workbook s with kutools for excel. 2 click file print. To change the print selection close print preview by clicking on the x and repeat the previous steps.

So the bigger your worksheet the more pages it will take. Note that all of the worksheets that you are trying to print must be part of the same excel workbook. To print the entire worksheet click file print print make sure entire sheet is checked and click print. 3 go ahead to select print active sheets in the drop down list below settings specify a printer and click the print button.

You can shrink your excel document to fit data on a designated number of pages using the page setup option in the page layout tab. By default excel prints sheets at their actual size. If you have the excel desktop application you can set more print options. Click the small dialog box launcher on the bottom right.

How to print multiple worksheets on a single page in excel 2013. To print an excel sheet on one page choose one of the following scaling options that reside at the end of the settings section in the print preview window. Excel sheets can compile a lot of data and it s not always convenient to print it all at once. This article will show you methods of printing only certain or specific worksheets in excel.

By scaling your worksheet for printing you can make your data fit to one page. Holding the shift key you can select multiple adjacent sheet tabs with clicking the first one and the last one. It is easy to print the active worksheet in excel. The steps in this article will show you how to change the printing settings in excel 2013 to allow for the printing of multiple worksheets within a workbook on one page.

Fit sheet on one page this. A similar process can be used to print selected sheets in a workbook. As you can see the first worksheet in the example workbook has two different groups of data. This setting tells excel what you want to print.

So the first thing to do is look at the current print preview. But in some cases print multiple certain worksheets at the same time is required. You can print certain sections of a spreadsheet by highlighting the target area going to the print settings and choosing the print selected area option. Holding ctrl key you can select multiple nonadjacent sheet tabs with clicking them one by one.

How to print excel spreadsheet on one page.