Print Only Specific Parts of a Worksheet in Excel

Add to Favorites

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

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...
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...
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...
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...
Reverse the Contents of a Cell in Excel - UDF
Macro: Reverse cell contents with this free Excel UDF (user defined function). This will mir...