X
X
The Best Tech Newsletter Anywhere

Join 350,000 subscribers and get a daily digest of news, geek trivia, and our feature articles.

Quick Tip: Print Only Selected Area From Excel 2007

How many times have you wanted to only print out a portion of the data on an Excel spreadsheet?  About a year ago I shared a tip to save ink and paper by only printing selected text from a webpage.  Instead of analyzing the spreadsheet, printing it out and reanalyzing it to find the pertinent data here I will show you how to print out the specific area.

With the spreadsheet open highlight the rows and / or columns you want to print out.

1

Next, click on the Print Layout Tab on the Ribbon.  In the Page Setup section click Print Area and then Set Print Area.  This will show a perforated outline around the selected rows and columns.

1

Now just hit the Quick Print or go to the Office Button and Print.  Now only the selected area will be printed out!  Simple but effective tip!  Also, this can save printer ink and paper which is always good for Green Computing.


The above article may contain affiliate links, which help support How-To Geek.
How-To Geek is where you turn when you want experts to explain technology. Since we launched in 2006, our articles have been read more than 1 billion times. Want to know more?

x

The Best Tech Newsletter Anywhere

Join 350,000 subscribers and get a daily digest of news, comics, trivia, reviews, and more.