• Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Home
  • Categories
  • Contact Us
    • Advertising
    • Requests
    • Privacy Statement
HelpSpa.com

HelpSpa.com

Computer Tutorials

Excel 2010: How to Select or Change the Print Area

September 24, 2010 by davidwank

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.

Filed Under: Excel, Microsoft Office Tagged With: Excel

Primary Sidebar

More to See

Google Analytics 4 Migration Training

December 22, 2022 By davidwank

Hubspot Zoom Webinar Integration

Connecting HubSpot and Zoom Webinars

August 27, 2022 By davidwank

Google Analytics as we know it is going away!

July 24, 2022 By davidwank

Footer

Text Widget

This is an example of a text widget which can be used to describe a particular service. You can also use other widgets in this location.

Examples of widgets that can be placed here in the footer are a calendar, latest tweets, recent comments, recent posts, search form, tag cloud or more.

Sample Link.

Recent

  • Google Analytics 4 Migration Training
  • Connecting HubSpot and Zoom Webinars
  • Google Analytics as we know it is going away!
  • Building a New Dental Website?
  • BackupBuddy Timeouts on GoDaddy Hosting

Search

Tags

Adobe Acrobat Backup classical music and opera cPanel DAM Database Digital Photography email Excel Facebook Firefox hardware HP Security HTML iMovie Internet Explorer iTunes linksys Microsoft Office Microsoft Word MySQL networking Office 2010 OneNote OpenOffice OS X PDF PHP printers reseller hosting Reviews router SEO subversion Video Virtualization Virtual PC Web Design Web Development Web Hosting Windows Windows 7 Windows Vista Windows XP Wireless

Copyright © 2025 · Magazine Pro on Genesis Framework · WordPress · Log in