How to Print Selected Cells in Excel

Microsoft excel deals with numbers though sometimes it is also helpful for storing data. Additionally, we need a hard copy of this documentation at times, and then comes the need to print the spreadsheet. If we want to print the whole worksheet or workbook, we can directly use the Print option. However, sometimes we need to print only some selected cells, and we cannot proceed directly; we need to make some alterations before printing. This article will demonstrate six different ways to print selected cells in excel.


Download the practice workbook here.

Printing Selected Cells.xlsx

Print Only Selected Cells in Excel with These 6 Methods

Firstly, let us get acquainted with our dataset used throughout the article as an example. This spreadsheet is a list of countries and their corresponding capital and currencies. The dataset contains four columns containing Serial Number, Country name, Capital, and Currency. We will use this dataset to demonstrate the six different methods to print selected cells in Excel. 


Method 1

Using the Print Option

The simplest way to print only selected cells in excel is to use the print option. Let us see how to do that,

⬇️⬇️ STEPS ⬇️⬇️

  • First off, select the cells you want to print.

Print option-print selected cells in excel

  • Next, in the ribbon, go to the File menu.

  •  Then, select Print or you can press only Ctrl+P.

  • Then from Print settings, you need to select Print Selection Option.

Print selection-to print selected cells in excel

  • Lastly, in the Print Preview area you will see the selected cells and if it is appropriate then press the ‘Print’ option to print.

  • At last, the sheet’s output will resemble the image below.

Output using print option-to print selected cells in excel


Method 2

Applying Print Titles Command

Next, we will look upon the Print Titles command to print selected cells in excel in this method. Let us see the steps.

⬇️⬇️ STEPS ⬇️⬇️

  • First, in the ribbon, go to the Page Layout tab if you are in another option.
  • Then select the Print Titles command.

  • A box named Page Setup would appear then. Set ranges in the Print Area of the Page Setup Box

  • Or just click on the Arrow.

Page setup box-to print selected cells in excel

  • And select the cells.

Print area-to print selected cells in excel

  • Then press the OK button if you want to print later.

Page setup-to print selected cells in excel

  • Or you can proceed to print by pressing Print.
  • Finally, the printed sheet will appear as shown in the image below.

Print titles output-to print selected cells in excel


Method 3

Employing Print Area Command

This method will use the Print Area command to select the desired cells before printing. Let us go through the steps.

⬇️⬇️ STEPS ⬇️⬇️

  • Firstly, select the desired cells.

Print area command-to print selected cells in excel

 

  • Then, go to the Page Layout option in the ribbon, press Print Area, and select Set Print Area from the two options.

Set print area-to print selected cells in excel

  • Now, the print area has been set for the selected cells. Use the keyboard shortcut Ctrl+P or go to the Print option from the File menu to print the selected cells.
  • Finally, the printed sheet will look like the image below.


Method 4

Applying Named Ranges

In the following method, we will use the named ranges option to select desired cells. Let us demonstrate the steps.

⬇️⬇️ STEPS ⬇️⬇️

  • Now, select the cells to print.
  • Then, in the Name Box, type Print Area.

Named Ranges-to print selected cells in excel

  • Now, the print area has already been selected. So, to print the cells, press Ctrl+P and then Print to complete the process and you will get a printed worksheet like the image below.


Method 5

Utilizing Page Break Preview to Print Selected Cells

Now, we will use Page Break Preview to set our cell range to print them later. Let us see the steps.

⬇️⬇️ STEPS ⬇️⬇️

  • We need to go to the View tab first and select Page Break Preview.

  • Then, move the border across the cells according to the requisite.

Page break preview-to print selected cells in excel

  • Similarly, by dragging the border lines from all four sides, we can select our desired cells like the picture below.

Page break preview-print selected cells in excel

  • Then select Normal view to exit the Page Break Preview.

Normal view-to print selected cells in excel

  • Lastly, go to the Print option from the File menu and press Print and the output of this sheet will look like the image below.

Output using page break preview-to print selected cells in excel


Method 6

Making Use of Page Setup Dialog

In this step, we will use the group Page Setup for the selection. Let us go through the steps.

⬇️⬇️ STEPS ⬇️⬇️

  • First, go to the Page Layout menu and select Page Setup

  • Then a dialog box named Page Setup will appear. From there select the Sheet tab.

  • Now, to select the cells, type the cell range in the Print Area section or press the Arrow key on the right side of Print Area and select the desired cells.

Page setup dialog box-to print selected cells in excel

  • Then press OK, and the print area will be selected.
  • Later, we can print it by pressing Ctrl+P and then Print.

  • Or else we can press Print if we want to proceed immediately.

Page setup-to print selected cells in excel

  • Lastly, the output of the sheet will look like the picture below.

Page setup output-to print selected cells in excel


📄 Important Notes

🖊️  You can use the keyboard shortcut Ctrl+P to print excel sheets instead of going to the File tab and then the Print option 

🖊️  Make sure to always check the Print Preview before printing the sheets.

🖊️  You can use Custom Scaling Option to fit your selected cells according to your choice. 


📝 Takeaway from This Article

📌  This Article demonstrates six different ways to print selected cells in Excel.

📌  In the first method, we used the Print option. After selecting the desired cells and pressing Ctrl+P, we select Print Selection from Print Settings. 

📌  Next, we used the Print Titles option from the Page Layout menu to select our desired range of cells and proceed to print by usual means.

📌  Then we demonstrated that after selecting cells, set the print area by using the Print Area option from the Page Layout menu.

📌  After that, we showed setting print area by typing the Print Area command in the Name Box.

📌  Page Break Preview is another easy method to select the cells before printing.

📌  Lastly, the Page Setup group from the Page Layout menu allows selecting cells according to the requisite.


Conclusion

This article has demonstrated six diverse ways to print selected cells in excel. All these methods are incredibly effective and simple to use. We hope this article helps you. Please leave a remark if you have any queries. The author will do their best to find an appropriate answer.

For more articles like this, visit Excelden.com.

(Visited 196 times, 1 visits today)
Priti

Priti

Hello! Welcome to my Profile. I am Priti. I'm now working and researching Microsoft Excel, and I'll share articles on it here. I am passionate about problem-solving, and I hope these articles will help you. Please leave a remark if you have any queries, and I will do my best to find an appropriate answer.

We will be happy to hear your thoughts

Leave a reply

ExcelDen
Logo