Quantcast
PCWorld.com is upgrading some back-end systems. Some site features, such as user registration, may be temporarily unavailable.

Excel for Environmentalists

Save some trees by printing only the cells you need from your large Excel spreadsheets.

JoAnne Robb

  • 0 Yes
  • 0 No

You don't need to throw out reams of paper just to get hard copies of a few key areas of your Excel spreadsheets. Instead, just print noncontiguous sections--without laboriously cutting and pasting those sections into a separate sheet.

On your worksheet, highlight the first range of cells that you want to print. Next, hold down the Ctrl key on your keyboard and scroll to the next section you'd like to print, then highlight the second range of cells. And don't let go of that Ctrl key!

You can highlight as many noncontiguous sections as you want to print, as long as you continue to hold down the Ctrl key while doing so. When you're done making your printing selections, click File, Print and choose the Selection radio button in the box titled "Print what."

Excel prints each separate, noncontiguous section on its own page. If you want to preview the print job first, click the Preview button in the Print dialog box. Otherwise, just click OK in the Print dialog box to print your selection.

  • Recommend this story?
  • 0 Yes
    0 No
  • Great year-end deals
    for small business!
  • Get 24/7 live remote AT&T Tech Support 360* service along with select Lenovo* PCs (with Intel® Core™ 2 Duo processors) and save up to 200!

    Learn more

  • HP EliteBook* 6930p Notebook with Intel® vPro™ technology and a free HP Basic Docking Station - $641 instant savings!

    Learn more

Learn more about the Windows Phone PCWorld Gift Guide

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:

Sponsored Links