Thursday, June 16, 2011

How to Reduce a Worksheet Size in Excel 2007


1. Open the Microsoft Excel 2007 file on your computer that contains the worksheet for which you want to reduce the size.
2. Click the 'Page Layout' button from the bottom of the application to switch to the Page Layout view.
3. Select the 'Page Layout' tab and then select the '1 page' option from the 'Width' drop-down menu in the 'Scale to Fit' group.
4. Select the 'Automatic' option from the 'Height' drop-down menu.
5. Click the 'Scale' drop-down menu to select a smaller scale size if you want to reduce the worksheet size even more. Click 'OK' to save your changes.

Blogger news