Print Only Specific Parts of a Worksheet in Excel

Add to Favorites
Author:

In Excel you can select parts of a worksheet to print while ignoring all of the other data on the worksheet.

This allows you to select sections of important data to print without having to move those sections of data to other spreadsheets in order to print them.

You can select a single part of a worksheet or multiple parts of a worksheet to print.

Steps to Print Specific Parts of a Worksheet in Excel

  1. Select the part of your data that you want to print. (If you are printing multiple sections on your worksheet, you can select these sections by hitting Ctrl and selecting them now or wait for step 4):
  2. Go to the Page Layout tab and click the Print Area button and then click Set Print Area (for Excel 2003, go to the File menu and then Print Area and then click Set Print Area):
  3. Once you do this, you will see a dotted outline around the area that you just set to be printed:
  4. Now, if you want to select more areas to print, simply repeat steps one and two as much as needed, except that instead of clicking Set Print Area, you will now click Add to Print Area:
  5. Those specific sections are now ready to be printed:
  6. Go into Print Preview and you can see how they will print (File > Print in excel 2010 and later - File Print Preview in Excel 2003 - Office Button > Print > Print Preview in Excel 2007):

Here, Excel put both sections on different pages and, given that our printed data set is quite small, it doesn't look so great.  But, how it looks will depend on your data setup and the other print options that you choose.

Remove a Set Print Area so the Entire Worksheet will Print Again

This is quite easy.

Go to Page Layout tab > Print Area > Clear Print Area:

And here is the result:

Notes

Setting the print area for a worksheet is one of the most useful tips for printing in Excel, especially when working on large spreadsheets, but it is not the only tip for printing in Excel. Make sure to check out our section on printing tutorials for Excel so you can see other tips for making your printed spreadsheets look nice.

When you close the Excel file, the print areas will be automatically removed.  Make sure to print the document before you close and reopen it.


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
Remove Gridlines from Only Part of a Worksheet in Excel
Tutorial: How to remove gridlines from a part of a worksheet in Excel instead of the entire workshe...
Get the Name of a Worksheet in Macros VBA in Excel
Tutorial: How to get the name of a worksheet in Excel using VBA and Macros and also how to store tha...
Remove All Filtering From a Worksheet in Excel
Macro: This Excel macro removes all filtering from a worksheet in Excel. This allows you to compl...
Quickly Reset All Form Controls in a Worksheet in Excel
Tutorial: How to reset all Form Controls on a worksheet in Excel with the click of a button or two ...
Quickly Move Cells Around a worksheet in Excel Cut/Paste Trick
Tutorial: Moving Cells around a worksheet in Excel is fast an easy. Below I have a table of forename...
Change the Name of a Chart in Excel
Tutorial: How to change the name of a chart in Excel. This allows you to use a more intuitive char...
Tutorial Details
Downloadable Files: Excel File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course