HelpSpa.com
Search HelpSpa.com

Excel 2010: How to Select or Change the Print Area

September 24, 2010DavidExcel, Microsoft Office1

Unlike in Microsoft Word where a page is page, Excel 2010 (and, in fact, all previous versions) don’t really understand the concept of a “page”. Thus, in order to print using Excel, it’s up to the user to let Excel know what data you want on a page. In Excel, the area of a spreadsheet (worksheet) to be printed is called the Print Area.

Excel will generally automatically set the print area, but if you print your worksheet and find that it isn’t printing correctly, you should consider adjusting the print area.

To adjust the print area:
1. First select the area you want to print (hold down the left mouse button and drag to select the area)

2. Making sure the area is still selected, in the Excel 2010 menu bar, select the Page Layout tab and the Print Area button (the area should still remain selected).

excelPrintArea1g

3. In the drop-down menu that appears, click “Set Print Area”.

excelPrintArea3g

Now when you print you will be only printing your selected print area.

Tagged

Related Posts

One Comment

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

    [...] to fit into a normal 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, [...]

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