Excel 2007 - Printing of excel sheet to fit to page size
The Ms Excel is a different animal when it comes to printing. Because of the nature of the format, you could be selecting only a fraction of page/sheet or workbook to print. For a casual excel user like me, this give inconvenient when all i care is to be able to print what i see on that particular page (or call sheet in excel). Often time, you would see some fraction of the content is being crop out in the print out. Because of exceeded range, you need to resize the columns one by one so then to be able to see the print out in one page. This is time consuming and frustrating. So, after some digging, I found my all time favorite Fit to Page printing function. It is located in "Page Layout" segment.And then, there is a "Scale to Fit" band next to page setup band. (that is another frustration of using newer version of office , all the menu items have been revamped, need time to search for what you want like in the past version). However, this would not wor