Print Excel Spreadsheet on 1 page

How many times have you printed an Excel spreadsheet only to find out that 2 pages printed? Bummer when you realize how pathetic that second page looks with one column on it or just a few rows of data.

There is an easy solution that will get that spreadsheet scaled to make it fit 1 page.

First click the Page Layout tab.

page layout tabe

Locate the Scale to Fit group. Change the width to 1 page from automatic and change the height to 1 page.

scale to fit group

After switching to 1 page you are all set to go assuming that the scale is about 70% or higher. It will be grayed out. The higher the number the less the spreadsheet had to make it a smaller font size.

Tip: Save the spreadsheet as a PDF. Using Excel 2010, click File–>Save As then pick PDF from the format drop-down list. If you have Office 2007 Excel, you first have to download the free Office 2007 Save as PDF ad-in from Microsoft.


About Steve Chase

I'm a proud husband and dad to 4 boys! Microsoft Certified Trainer and Boy Scout Leader are some of things I call myself. The Cincinnati Reds are my favorite team! When not outdoors, I enjoy working with documents in Microsoft Office, QuickBooks, Visio and Photoshop. My wife, Erin, shares her awesome recipes on her blog at
This entry was posted in Excel and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s