Make Worksheets Fit Better on a Page

1. Choose Page Layout => Scale to Fit and then click the Scale to Fit dialog box launcher.
   
   
   
   
   
   
2. The Page Setup dialog box opens. From the Scaling area, make a selection from the options.
   
   Adjust To:
   Enlarge or shrink the printed font size by setting a percentage option between 10 and 400.
   Do not try to shrink the document too much. Because Excel shrinks the font, trying to fit too much on a page can make the document typeface too small to read.
   
   Fit To:
   Force Excel to a specified number of pages wide and high.
   
   
3. Click ok.