Quantcast
PCWorld.com is upgrading some back-end systems. Some site features, such as user registration, may be temporarily unavailable.
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

Featured APC Accessories

  • 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:

  • 15 Minutes to a Secure Business Get the Secure in 15 toolkit starting with the "15 Minutes Month-at-a-Glance" calendar. McAfee will send you additional tools and tricks to stay protected around the clock.
  • A Buyer's Guide to Data Protection Implementing data protection products and processes can be daunting. Make the right decisions by exploring what is available and what makes sense for your organization. Use this simple guide to evaluate different vendor offerings.

Sponsored Links