Friday, November 11, 2011

How to Print a Large Excel Spreadsheet


1. Set the print area by selecting the top left corner of the area you wish to print, and dragging to the bottom right. This will create an outline around the area you wish to print. Click 'File,' 'Print Area' and 'Set Print Area.'
2. Click 'File' and 'Print Preview.'
3. Set the page size to the paper you will be using. The standard is A4.
4. Set the scaling. Try checking 'Fit to one page(s) wide by one page(s) tall' box. If the percentage showed in the toolbar changes to below 40 percent, the text will probably be too small to read. If not, click on the page to view a print preview and check if the spreadsheet is big enough to be understood. Choose a bigger percentage if not.
5. Reset the margins. You may need to click the 'Margins' icon in the toolbar to show the margins if they do not show up automatically. Drag along the margin to shrink it, and create more usable space.
6. Click 'Print.'

Blogger news