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 work magically. You need to be accustomed with some of the Excel specific printing function.
The 3 steps below.

The first thing you need to do is to set "Print Area" in the Page Setup band.
Then, in the Scale to Fit band, you need to set the Width and Height. You have to roughly estimate how much pages you need for your print out. For instance, 2 pages in Heights if you need print out in two pages. Also, in the scale to fit, you need to set the orientation right.(portrait or landscape).

You can of course by pass these 3 steps but you would probably get a miniature print out with improper zoom out and wasting a lot of blank space.

So, this is the summary of the steps,
1. Select Scale to Fit, choose orientation
2. In Scale to Fit, number of pages in heights.
2. Set Print Area. Include only cells with data.

That is all. have fun with printing.

Comments

向著星球長驅直進的人,反比踟躕在峽路上的人,更容易達到目的。...............................................................
Janice said…
I spent an hour looking for your tip--none of the official books, tutorials, etc. had it accessible.

You are brilliant, understandable, and worth way more than their instruction manuals. THANK YOU!!!

jmarshal

Popular posts from this blog

Clearcase check in/uncheck out all the checked out files script

MSSQL GROUP_CONCAT

Duplicating a local copy of project from TFS and making web software client factory to work