Tuesday, August 13, 2013

How to Fit an Excel Sheet on One Page


1. Open the Excel spreadsheet that you want to print. Click on 'File' in the Excel toolbar, or use the keyboard shortcut 'Alt' and 'F.'
2. From the 'File' menu, select 'Page Setup.'
3. In the 'Page Setup' dialog box, click the 'Page' tab.
4. Under 'Scaling,' click the radio button to the left of 'Fit To.'
5. Enter your desired number of pages in the 'Pages Wide' and 'Pages Tall' drop-down menus. For example, you may want to change only the width of your page so that the last columns do not print onto a separate page. In this case, you would enter '1' into 'Pages Wide' and delete the number in the 'Pages Tall' menu.
6. Click OK. Your Excel spreadsheet will now fit the way you want it to.

Blogger news