Print Excel Spread Sheet On One Page
Excel is great application for managing numeric as well as other information. It can add columns, create series and a host of other functions. But there is one thing by default that leaves something to be desired. Printing! I have been asked many times if there is a way to get an Excel spread sheet to fit on to one page when printing. Well the answer is a yes, and it’s easy to do. Be warned thought, while you do have the ability to fit a spread sheet on to one page this will reduce the font size and may make you spread sheet hard to read.
Setup Excel To Print On One Page
1. Click File > Page Setup
2. On the Page tab select the ‘Fit to’ setting in the scaling area. Set both scaling properties to 1. (1 page wide by 1 page tall)
Now just click ‘OK’ and your spread sheet will print on one page. As stated earlier printing a spread sheet on on page will reduce the size of the text. The is not a global setting in Excel meaning that you will have to adjust this setting for every spread sheet you want printed on one page.
