30 Advanced Excel Tips for 2026

Excel Champs / Excel Basics / How to Print Only Selected Cells in Excel (Certain Cells)
By Puneet Gogia (Microsoft MVP)

How to Print Only Selected Cells in Excel (Certain Cells)

30+ Advanced Excel Tips for 2026

No spam. Only Excel Stuff. God Promise. 😊

Select the cells, press Ctrl + P, and under Settings change Print Active Sheets to Print Selection. The preview shows only your range; click Print.

If you print the same range again and again, set a print area instead: select the cells and go to Page Layout → Print Area → Set Print Area. Excel saves it with that worksheet, so every later print uses it until you choose Page Layout → Print Area → Clear Print Area.

To extend a print area, select more cells and choose Page Layout → Print Area → Add to Print Area. To print the whole sheet once without clearing it, pick Ignore Print Area from the same drop-down in the Ctrl + P screen.

Ranges picked with Ctrl that aren’t next to each other print on separate pages, one range per page. To get them on one page, hide the rows and columns between them and print the block as one selection; hidden rows and columns don’t print.

If the selection still spills onto a second page, change No Scaling to Fit Sheet on One Page in the same Settings list. When the active cell sits inside an Excel table, the list also offers Print Selected Table, which prints that table alone.

In Excel, there is an option that, when used, prints only the selected cells.

This option is helpful when you have a huge amount of data in the sheet but only want to print specific cells.

There are two ways to print certain selected cells: the first is to use “Print Selection,” and the second is to use the print area. In this tutorial, we will walk through both methods in detail.

Steps for Printing the Selected (Specific) Cells in Excel

It is a quick method to print the selected range of cells. You don’t need to change anything; the option is right in the Print screen.

print-selection

You can use the below steps:

  1. To begin with, you need to select a range of cells (you can also select multiple ranges) that you want to print.
  2. Now, go to the File Tab and click on the print option inside the file tab. Once you click the print option, you will see the print preview and all the print settings.
  3. Next, in the print section, click on the drop-down where you have “Print Active Sheets”. And from this drop-down, select “Print Selection”.
  4. Finally, in the print preview, you can see that it only shows you the cells or the range you selected for the print. So now, click Print to print the data.

Important: Excel will print each cell or range on a separate page when you select multiple cells or ranges (non-contiguous) and then use the “Print Selection” option.

Notes on Printing Selected Range

  1. If you change the settings to “Print Selection,” you don’t need to apply this setting repeatedly. Instead, use the keyboard shortcut Ctrl + P or the File tab > Print.
  2. Print Selection doesn’t mean the data prints on a single page. It moves data to the next page if Excel can’t fit it on one page (use the scaling option “Fit Sheet on One Page” if you need that).
  3. The “Print Selection” option provides access to all other printing options.
  4. Print Selection prints the cells that are selected at the moment you print, so if you select other cells, Excel prints those instead. If you want the same range every time, use the print area, which is saved with the worksheet.

Quick Tip: If you have an Excel table in the worksheet and want to print data only from that table, you can select the “Print Selected Table” option.

Using Print Area to Print Selected Cells

You can specify the print area to print only the selected cells. Once you select the range you want to print, go to the Page Layout Tab > Print Area > Set Print Area.

set-print-area

Once you set the print area, a light grey border will be added around the selected data.

light-grey-border-around-the-data

Afterward, go to the File Tab and Print or use the shortcut key Ctrl + P to see the print preview.

Now, the print preview shows the data from the range you have selected and specified as the print area.

What is Print Area Command/Option?

In Excel, “Print Area” is a handy option that enables users to specify a particular range of cells they intend to print.

This becomes especially valuable when working with extensive spreadsheets containing a large volume of data, but only a specific section needs to be printed.

It allows for more efficient printing, letting you focus on the essential parts of your data.

Instead of printing an entire worksheet, you can highlight the cells with the needed data and set that as the Print Area.

If you need to change the print area in your Excel worksheet, here are the detailed steps:

  • Select the new range of cells you want to set as the print area. Click and drag your mouse across these cells to highlight them.
  • After selecting the range, navigate to the ‘Page Layout’ tab. This tab is in the toolbar at the top of the Excel screen, usually between the ‘Formulas’ and ‘Data’ tabs.
  • Look for the ‘Page Setup’ group within the’ Page Layout’ tab. This group contains several printing and page setup options, including the ‘Print Area’ option.
  • In the ‘Page Setup’ group, click ‘Print Area’ and choose ‘Set Print Area’. This replaces the old print area with the new range.

Your worksheet’s print area is now set to the newly selected cells. To adjust the print area of your worksheets, repeat these steps as often as needed.

Clear the Print Area

To do this, go to the “Page Layout” tab. The Print Area drop-down has an option called “Clear Print Area.” Once you click on this option, the set print area will clear.

clear-print-area

You can now set a new print area or simply print using the default settings.

Why the Clear Print Option is Useful

When you want to switch back to printing the entire worksheet, the ‘Clear Print Area’ option comes into play.

When you choose this option, the previously set print area is removed.

This means the entire worksheet will be printed the next time you print the document instead of just printing the previously specified area.

It’s also important to note that the ‘Clear Print Area’ option does not delete any data from your worksheet.

It simply changes the print settings to their default state, enabling the entire worksheet to be printed.

Set Print Area Vs. Print Selected Cells

Now, you know you have two options to print selected cells. These options do the same thing but are useful in different situations.

  • Set Print Area can be used when repeatedly printing a set of cells. It saves you from selecting those cells again every time you print with Ctrl + P.
  • Print Selected Cells allows you to print only the specific selected cells or the selected area of the worksheet. Each time you need to print, you must choose those cells again. It is also useful when printing the selected cells, but the selection is not fixed. That means you can change the range to print by choosing a new one.

Other Points to Note Down

  • Remember that any formatting you apply to your selected cells, such as borders and shading, will also appear in your printout.
  • The flexibility of the Print Area function in Excel allows you to adjust the print area at any point. This is especially useful when there are data changes or printing needs.

Set Print Area from Print Titles Command

To open the print titles option in Microsoft Excel and use it for your advantage, follow these steps:

use-print-title-for-setting-print-area
  • Once you open the Excel worksheet, navigate to the ‘Page Layout’ tab. This tab is in the toolbar at the top of the Excel screen. It’s usually between the ‘Formulas’ and ‘Data’ tabs.
  • Within the ‘Page Layout’ tab, look for the ‘Page Setup’ group. This group contains several printing and page setup options, including the ‘Print Titles’ option.
  • Click on the ‘Print Titles’ option within the ‘Page Setup’ group.
  • In the Page Setup dialog box, go to the ‘Sheet’ tab. To set the print area, click on the arrow button next to the Print area box. Then select the range that you want to set as the print area, and click OK to save.

Add More Cells to the Print Area

Once a print area is set, you don’t need to set it again to include more cells. Select the new cells, and go to Page Layout ➜ Print Area ➜ Add to Print Area. If the new cells aren’t next to the existing print area, Excel prints them on a separate page.

Each worksheet has its own print area, and it’s saved with the file. Excel also creates a hidden name called Print_Area for it, which you can see in the Name Manager.

Set the Print Area with VBA

If you print the same range from many sheets, you can set it with a macro. The first line sets the print area, and the second one prints only the current selection:

Sub print_selected_cells()
ActiveSheet.PageSetup.PrintArea = "$A$1:$D$20"
Selection.PrintOut
End Sub

To clear the print area with VBA, use ActiveSheet.PageSetup.PrintArea = “”.

Frequently Asked Questions

Why is Excel still printing the whole sheet?

Check the first drop-down under Settings in the Print screen. If “Ignore Print Area” is ticked there, Excel prints the whole sheet even when a print area is set.

How do I print selected cells on one page?

Select Print Selection, and then choose “Fit Sheet on One Page” from the last drop-down under Settings. This works only for a single range; separate ranges always go on separate pages.

Can I set a print area on several sheets at once?

Not with the Set Print Area button, as it works on one sheet at a time. Set it on each sheet, or use the VBA code above in a loop through the sheets.

Puneet Gogia

Written by

Puneet Gogia

Microsoft MVP — Excel · Founder, Excel Champs

Twelve years of teaching Excel, and a decade before that using it as a data analyst. Every tutorial here is written from a file I actually built.

3M+ readers helped
1,000+ tutorials written
Since 2015 teaching Excel

Leave a Comment