Friday, 12 June 2009

Printing from Excel - Part 1

Printing from Microsoft Excel is markedly different to printing from Word. Whereas in Word we can usually just tell it to print without worrying that much about formatting the page, in Excel we will usually have to specifically tell it how we want to print our speadsheets, and this can sometimes be a little fiddly. Because there is quite a lot of fiddling that can be done I have split these instructions over two posts.


Pictured above is an example of a spreadsheet - in this case a dataset of U.S. population information. Exciting, I know. When I press the Print Preview button [pictured right] I see the following:


As we can see, not all the columns are shown on the first page. If I go down to page 6 we can see the missing column.


To remedy this situation I click the 'Setup..' button in the Print Preview. This opens up the following option box.


I could change the orientation to 'Landscape' as this would enable the missing column ; however, for the purposes of this tutorial I will keep it set to 'Portrait'. Instead, I reduce the scaling until the final column appears on the first page. In this case I set it to 80% of normal size.


I could also have achieved the same result by selecting all the data and reducing the font size, the column width and row height; although I find adjusting the scaling to be easier. The Print Preview now looks like this:


As yet there are no page numbers shown. In order to have page numbers displayed I click 'Setup..' again and open the 'Header/Footer' tab. Here I can select whether I want the page numbers to be shown at the top or the bottom of the page by choosing an option from the appropriate drop-down list, two of which are shown below.


As you can see from the drop-down lists, there are other options available for what will be displayed in the header or footer, including file name and date. I now have a serviceable format for my document that I can print out. At the same time I have reduced the number of pages from ten to four. There are a number of other print formatting options available that I will explore in the next post.

5 comments:

Brandy said...

Great tutorial! I already am very good at using Excel, however, feel you wrote a great post on how to!

Just stopping by for the EC drops and noticed this post, wanted to comment!

Thanks,
Brandy from HappilyBlended.com

Tamal Anwar said...

Hello there, we're building links from tech blogs. Our site is located at http://securitysoftwaresdownload.com/

Would you like to add our link on your sidebar? If you do so, we can give you a free copy of Registry Easy.

"Registry Easy is the recommended registry optimizer tool for users like you and world class PC experts. It successfully repairs broken registry items and junk files. makes your PC run faster and smoother."

Please let us know via email if you're interested: john@moneyevent.com

Stepterix said...

Thanks for the comments.

Shown said...

I was frustrated from my PC due to window registry errors and crashes. My friend told me to download registry easy for remove window registry files and invalid entries and he gave me your reference then I downloaded registry easy from your web site and I have choose your site as a bookmark.

Stepterix said...

Shown: I'm glad to have been of help.