Let's say you are working with a large spreadsheet and when you print your workbook, it uses many papers and still you don't get the results you want.You want to print using minimum pages which covers all useful information
Let's see how we can use the print features in excel.
We have the large spreadsheet with 2000 rows and 12 wide columns. Now if we print directly without changing any printing parameter it takes 344 papers and still we don't get the appropriate print.
Press Ctrl+P and click on Preview (Excel 2007)
Download file: Tips to Print large spreadsheet
Let's see how we can use printing option to reduce paper.
1. Hide Rows and Columns which are not required: Before going ahead, first check that if all the columns and rows are required for printing. May be some of the columns with calculations or extra information are not required to print.
Here we hide last column which reduces page numbers to 258 from 344.
Adjust Row and Column width: If the column titles are larger than required adjust column width to remove extra space. You can use the Autofit Column width option.
2. Change the Orientation of Page-Portrait /Landscape
If you have many columns which cannot be fitted in portrait mode, use Landscape orientation.If you have few columns then Portrait orientation will be more useful.
Changing orientation will also reduce no of papers required from 258 to 236.
Related Article: How to set page layout for perfect printing?
3. Fit data in one page across
It is important that we see all the columns data in one pageto get the overall details.
To set page size, Go to Page layout-> In Scale to fit group, set Width:1 Page and Height: Automatic.(Excel 2007 and 2010)
For earlier version you can set page layout using page setup.
Excel will automatically set the each column width to manage data in one page.It will drastically reduce the page Numbers for printing. Here you can see the no of page reduces from 236 to 19.
If it is not possible to set page width in one page across, you can use Page break to decide where you want to split data to another page. Read more: How to use page breaks for perfect printing?
4. Set Margins: To set the margins Go to Page Setup->Margins in print preview mode.
Set the margins from all borders. It will reduce the free space around the page. You can also align the page in the centre of the page.
For example, we have set all margins and header –Footer area to 0.5.
5. Print Titles: Provide Row and Column titles to give the meaning of each page of print.
Method 1: Go to Page layout-> Select Print Titles
Method 2: In Print Preview mode, Go to Page Setup and select Sheet Tab.
Read more: How to print Titles on every page?
General Tips you should be aware of:
-If it is large spreadsheet then A4 size paper may not show correct result. If A3 size is available then choose A3 paper size. (Print Preview-> Page setup-> In Page Tab select Paper size as A3)
-Select option of Printing both side of paper which will reduce 50% of Total papers used. (Go Green!)
-If your data table does not have borders then choose the option of Gridlines.(Print Preview-> Page setup->Sheet Tab, click on check box of Gridlines)
-Provide you company logo, Page Numbers and Date in Header and Footer.
After doing this your worksheet is now ready for printing with minimum paper with great results.
If you find this useful, you can stay connected with us on facebook to get more amazing tips and tricks of Microsoft excel.
18,417 total views, 3 views today