Fit to Page Manually
If you do not want to shrink your spreadsheet objects or you tried the Fit to Page settings but are still having trouble making my spreadsheets fit to page, there are several page setup settings you can change.
Start with the page orientation. If you have your spreadsheet set to Portrait orientation but you have several columns after the end of the page, changing your page orientation to Landscape may solve the problem. In Excel 2003, go to the File menu, click Page Setup and go to the Page tab. Click Portrait or Landscape under Orientation. In Excel 2007 or 2010, go to the Page Layout tab, click Orientation in the Page Setup group and select Portrait or Landscape.
You can also adjust and customize the margins on the sides or top and bottom of the spreadsheet. In Excel 2003, go to the File menu, click Page Setup and go to the Margins tab. In Excel 2007 or 2010, go to the Page Layout tab, click Margins in the Page Setup group and select Custom Margins. Change the margin sizes, center the spreadsheet horizontally and vertically if desired and click Print Preview to see if you have been successful making my spreadsheets fit to page.
Use Page Break Preview to see where page breaks appear on your spreadsheet and to modify them, if necessary. Go to the View menu in Excel 2003 or the View tab in Excel 2007 or 2010 and select Page Break Preview. Adjust page breaks by clicking on and dragging them with your mouse.
Finally, you can change your font, column or row sizes to make your spreadsheets fit to page. Click the Select All button, which is the small gray box between A and 1 on the worksheet. With all of your data selected, change the font size in the formatting toolbar in Excel 2003 or the Font group of the Home tab in Excel 2007 or 2010. With all of the cells selected, you can quickly change all of the row or column sizes. Drag any row or column to the size you want and release the mouse. The remaining selected rows or columns will automatically be changed as well.
"Making my spreadsheets fit to page" no longer has to be an Excel problem for you!