Excel 2010: How to Select or Change the Print Area

September 24, 2010DavidExcel, Microsoft Office

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).


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


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


| 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!