How-To

How to Print Only a Specific Selected Area of an Excel Spreadsheet

There are times when you need to print out data from Excel. But often times you don’t need to print out the entire report which wastes paper, ink, and time.

There will be many times when you need to print out Excel spreadsheets at the office or home office. But oftentimes, you really don’t need to print out the entire report, which wastes paper, ink, and time. Here’s how to print out only the specific areas of the spreadsheet that you need.

Note: For this article, I am using Excel in Office 2013, but the principle is the same in other versions of Excel, too. The controls are just located in different areas on the Ribbon and toolbars.

Print Select Areas of Excel Spreadsheets

Start by opening the Excel spreadsheet you need, hold down the Ctrl key and highlight the area of the document you want to print out.

Select Area Excel Document

After selecting the area you want to print out, go to Page layout > Print Area > Set Print Area.

Print Area

You won’t really notice anything happen to the document at that point, but next, while still under the Page Layout tab, click Print Titles.

Print Tiles

Next, select the Sheet tab in the Page Setup windows that appears. From here, type in the Columns and Rows that you want to repeat (if any), then click on Print Preview. This allows you to include any headers or labels associated with the data.

Page Setup Excel

Now you will get a view of the area you’re printing out. And you can select the printer you want to use and adjust print settings. You can get deep into the printer settings. You can tweak the preview area and manually type in more cells if you want to include them.

Print Preview

If you get too deep into adjusting print areas, they will stay until you clear them out. From the ribbon under Page Layout, click Print Area > Clear Print Area.

Clear

This is a great way to save printer ink and paper, as well as time for you and your colleagues. Nothing is worse than someone printing out 500 pages when you need the printer to get one simple page.

Also, remember you don’t need to waste time and ink printing out entire web pages either. If you only want to print out specific info from an article, read our article: How to print only selected text from a webpage.

2 Comments

2 Comments

  1. Fernando Herrera

    Follow instructions to print an area.
    everything went exactly as the instructions
    but when a click print. I got a message:
    We didn’t find anything to print

  2. Rizky Amrin

    this is helpful, thanks!

Leave a Reply

Your email address will not be published. Required fields are marked *

 

To Top