Print Microsoft Excel Spread Sheet just on one page

While printing in excel there is easy way to ensure that you work sheet prints out as wide as possible but it should fit to one page in excel 2003 it is bit traditional while in 2007 it’s inbuilt function

In 2003 when printing open page setup the following window will open, here you need to specify the number of pages for width and tall, here is the trick you can play here

Click on Fit to and then specify the 1 in page width and leave the page tall blank, this will do the magic

In Excel 2007 and in Excel 2007 this function is inbuilt, in Print dialog box both Excel 2007 and Excel 2010 provide menu option Fit All Columns on One Page and this will do the same.