HelpSpa.com
Search HelpSpa.com

Excel 2010: How to Print Sheet on One Page

September 24, 2010DavidExcel1

I’m often asked how to condense an Excel 2010 spreadsheet for printing on one page — so in this post I will show you how to make that happen.

First consider that every spreadsheet is not meant to be condensed into one page — you can shrink any print area of an Excel spreadsheet into one page — but it may be unreadable at that size.

So to shrink the worksheet to fit (in Excel 2010 — it’s a little different from previous versions of Excel, but the concept is the same)

1. Select your print area.  (Here’s a quick review of how to set the Excel 2010 print area).

2.  Go to the File menu at the top left, of the screen:

excelFit0g

3. Select the Print option. You will see a choice at the bottom of the Settings area, Custom Scaling .

excelFit2g

In the custom scaling area you will see a list of scaling options. You can choose which one meets your needs — but “Fit Sheet on One Page” is the most basic choice and the one I’ll mention here.

Tagged

Related Posts

One Comment

  1. How to Show a Page Preview in Excel 2010 | HelpSpaMay 29, 2011 at 9:05 pmReply

    [...] 8.5×11 page. In the past I’ve always had to play around with setting the print area or condensing the spreadsheet to fit on one page.   But with the release of Excel 2010, there’s an easier way to see what your spreadsheets [...]

Leave a reply

Your email address will not be published. Required fields are marked *

*

| More

SpiderOak Online Backup, Storage, Access, Sync, and Sharing

We are currently offering a free copy of our 16-page eBook, "How to Organize your Digital Photography Collection" to everyone who signs up for our free newsletter. This eBook will review how to organize your digital photos, discuss metadata, and give you an overview of software than can help you with your digital photography workflow. Sign up in the signup area, located in the right-side column of every page on this site, and read your copy now!


Twitter Update