Quantcast
Subscribe to magazine

Print on the Range

Print the same cell range on multiple Excel worksheets.

JoAnne Robb

  • 0 Yes
  • 0 No

Here's the situation: you use a template spreadsheet to track the same information every month and keep each month's data on separate worksheets with the same layout. If you've been wondering how you can print the same selection from each worksheet without printing the whole caboodle and throwing away the pages you don't need, wonder no more.

To begin, go to the first worksheet of your spreadsheet--let's call it Sheet 1--and highlight the range of cells you want to print. Once you highlight those cells on the first worksheet, press and hold the Shift key while you click on any other worksheet tabs (in the bottom-left corner of the Excel window) that contain the same range of cells you want to print. As you click the tabs, they change color from gray to white.

Next, click File, Print, and highlight the Selection radio button in the boxed area titled "Print what." Now click the Preview button, and page through your print preview to make sure the right cells print on every page. When you're done looking over the preview, click Print.

  • Recommend this story?
  • 0 Yes
    0 No

Print 65% more pages than with refilled inks. Trust Original HP Inks. Hit Print Reliably.

Featured APC Accessories For Your System
10% Off Entire Cart at Online Store

  • APC Back-UPS ES Safeguards your equipment from damaging surges and spikes that travel along your utility & data lines.
  • APC SurgeArrest Performance Highest level of protection for your professional computers, electronics and connected devices, as well as provides surge protection.

Focus on Personal Productivitysponsored by Microsoft

  • Personal Finance 2.0 These free and fee-based Web services not only aggregate data from your online bank accounts, they give you tools for managing your money.
  • High-Tech Travel Tips Plenty of stories provide advice for elite mobile professionals. But what about you, the unproductive traveler?

People who read this also read:

  • 2007 Microsoft Office Suites Comparison This paper compares and contrasts four suites of the 2007 Microsoft Office system: Microsoft Office Standard 2007, Microsoft Office Professional Plus 2007, Microsoft Office Enterprise 2007 and Microsoft Office Ultimate 2007. This paper is intended to help organizations understand the applications and capabilities offered, and to identify the suite that best fits their needs.
  • Windows Vista Migration: The Business Proposition It's not so much a matter of "if" but "when" for most organizations regarding migration to Windows Vista. Laying the groundwork now for this migration can yield higher ROI than waiting until later. This Computerworld Technology Briefing explains it all.

PC World's Marketplace