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 Excel File
Download the practice workbook here.
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.
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.
- 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.
- 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.
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.
- And select the cells.
- Then press the OK button if you want to print later.
- Or you can proceed to print by pressing Print.
- Finally, the printed sheet will appear as shown in the image below.
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.
- Then, go to the Page Layout option in the ribbon, press Print Area, and select Set Print Area from the two options.
- 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.
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.
- 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.
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.
- Similarly, by dragging the border lines from all four sides, we can select our desired cells like the picture below.
- Then select Normal view to exit the Page Break Preview.
- 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.
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.
- 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.
- Lastly, the output of the sheet will look like the picture below.
📄 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.