Office
 

Microsoft Excel 2010 : Setting the Print Area

1/3/2012 3:26:28 PM

Setting the Print Area

Worksheets can include several rows and columns; setting the print area enables you to specify which rows and columns to print. If you don’t set a print area, all cells that contain data will print. The worksheet in this task contains four tables that span seven pages. By default, all will print unless you set a print area.



1. Click the File tab, then select Print to see a Print Preview of your worksheet.

2. Should your print area need adjusting, click on the Page Layout menu option to return to Normal view.

3. Select the exact cells you want to print (in this example, all the cells in the first two tables in this worksheet).

4. Click the Print Area command on the ribbon, and select Set Print Area. This will store the print area as part of the worksheet. Now, only the cells in the print area will print.


Tip: Another Way to Choose the Print Area

You can also Set the Print Area from the traditional Page Setup dialog box. To get there, go to the Page Layout tab and click the Page Setup dialog launcher. Once the Page Setup dialog box activates, you can click on the Sheet tab. There, you can set the Print Area input to the cell range you want to print.



5. Insert a row or column into your worksheet (PYTD Sales, for example). Parts of the table now fall outside the current print area.

6. Select the exact cells you want to print (now including the extra column).

7. To reset the print area to include the new row or column, choose Print Area from the Page Layout Tab, and select Set Print Area.

8. Your new print area is stored as part of this worksheet. If the new print area falls outside the margins, see the next task.


Note: Long and Short Dashes

The long dashed lines in your worksheet indicate the print area, and the smaller dashed lines indicate the current page margins. If your print area data falls outside the current page margins, you need to alter the page margins.

 
Others
 
- Microsoft Outlook 2010 : Setting Up Mobile Alerts for Important Messages
- Microsoft Outlook 2010 : Setting Up Calendar Alerts
- Microsoft OneNote 2010 : Searching for Stray Notes (part 2)
- Microsoft OneNote 2010 : Searching for Stray Notes (part 1)
- Microsoft PowerPoint 2010 : Managing Slide Masters
- Microsoft PowerPoint 2010 : Customizing and Creating Layouts
- Microsoft Access 2010 : Introducing Query Types & Creating a Query Using the Query Wizard
- Microsoft Word 2010 : Creating Different Headers or Footers for Odd and Even Pages
- Microsoft Word 2010 : Editing a Header or Footer
- Microsoft PowerPoint 2010 : Working with Placeholders
- Microsoft PowerPoint 2010 : Changing the Background
- Microsoft Excel 2010 : Using Print Preview
- Microsoft Excel 2010 : Using Excel with the Normal Distribution - The Central Limit Theorem
- Microsoft Outlook 2010 : Configuring Mobile Alert Settings for Exchange Server Accounts
- Microsoft Outlook 2010 : Configuring the Exchange Server Client - Configuring Security Properties & Configuring Connection Properties
- Using OneNote Web App : Finding Out Who Wrote Notes & Using OneNote Web App in Office 365
- Microsoft PowerPoint 2010 : Creating and Managing Custom Color and Font Themes
- Microsoft PowerPoint 2010 : Changing Colors, Fonts, and Effects
- Microsoft Access 2010 : Preventing Database Problems
- Microsoft Access 2010 : Securing Databases for Distribution
 
 
Most View
 
- Windows 7 : Windows Media Player - Learning the Basics (part 1) - Getting Around in Windows Media Player 12 - Navigating Menu Breadcrumbs
- SQL Server 2012 : Delivering A SQL Server Health Check (part 8)
- Windows 8 : Sharing and Securing with User Accounts - Add the Built-in Administrator Account to the Login Screen , Stop Entering Password on Lockout
- Windows 8 : Windows Store (part 1) - To open Windows Store, To review and purchase an app from Windows Store
- Windows Server 2008 : Creating and Running a PowerShell Script - Running a Script Against Multiple Computers
- Installing Exchange 2013 : Versions, cumulative updates, and service packs (part 1) - Cumulative updates, Version numbers
- Microsoft Visio 2013 : A Visual Orientation to a Visual Product - Working with the ribbon
- Windows 8 : Running Programs and Apps (part 1) - Switching among open programs
- Microsoft Lync Server 2013 : Lync Hybrid Deployment - Moving Users Between Lync On-Premise and Lync Online
- Sharepoint 2013 : Navigate Through a SharePoint Site (part 1)
 
 
Top 10
 
- Microsoft OneNote 2010 : Searching Notes (part 4) - Troubleshooting Problems with Search
- Microsoft OneNote 2010 : Searching Notes (part 3) - Searching for Text with the Search Results Task Pane
- Microsoft OneNote 2010 : Searching Notes (part 2) - Searching for Text on the Current Page, Searching for Text with Instant Search
- Microsoft OneNote 2010 : Searching Notes (part 1) - Turning Audio Search On or Off, Turning Text Recognition in Pictures On or Off
- Microsoft OneNote 2010 : Prioritizing and Categorizing Notes with Tags (part 2) - Search for Tagged Notes, Removing a Tag from a Note
- Microsoft OneNote 2010 : Prioritizing and Categorizing Notes with Tags (part 1) - Applying a Tag to a Note
- Microsoft OneNote 2010 : Organizing the Pages and Sections in a Notebook (part 2) - Moving or Copying a Notebook Section, Merging One Notebook Section into Another
- Microsoft OneNote 2010 : Organizing the Pages and Sections in a Notebook (part 1) - Displaying the Hierarchy of a Notebook on the Navigation Bar
- Microsoft OneNote 2010 : Navigating Notebook Content with Links (part 2) - Notebooks list or click the Open Notebook button. Creating Wiki-Style Links to Other Locations in Your Notebook
- Microsoft OneNote 2010 : Navigating Notebook Content with Links (part 1) - Creating a Link to a Specific Notes Page, Creating a Link to a Specific Notebook Section