Not always, but at times you may need to print a few selected cells from a worksheet. You cannot perform this function easily by applying the same method you used for printing sheets and documents. There comes a difference when you need to print a specific area of the sheet.
So, how to print specific cells in Excel?
This process could be a little tricky for some users but in the end, you will find it friendly. Let’s see how it happens:
How to Set the Print Area in Microsoft Excel?
The selected range could be set as the print area when you often choose this range for printing. In this way, you don’t need to perform the process given below:
- Select the cell range that you need to set as the print area.
- Click on the Page Layout option and then choose Print Area.
- Select the Print Area option to choose the Set Print Area menu.
- Now, your selected area is set for printing.
- Whenever you need to print this area, it will be selected by default and you just have to click on the File tab and choose the Print option. Or else you can press CTRL + P from the keyboard. In case, you want to remove an area of printing, open the Page Layout menu and choose Print Area.
- Click on the Clear Print Area option.
That’s it!
How to Print Specific Cells in Excel with Print Option?
This super easy method invites you to perform this function smoothly. In this process, you need to select the specific cells and then apply the Print Option.
- Select the cell range you need to print. Suppose you need to print the Email, Customer Name, and Address only.
- Open the File tab.
- Choose the Print option or press CTRL + P.
- Choose the list-icon of print area settings from the Excel Print Settings menu.
- Choose the Print Selection option from there.
- In the print preview, you will see the selected cells only.
- Click the Print option and all done!
How to Print Specific Cells in Excel with Print Area Command?
With the Print Area command, you can easily manage to print specific cells because when a range is selected frequently for printing, the next time it is selected by default. You can then print that area easily.
- On the Excel ribbon, you will find the Page Layout option that we are going to use here.
- Select the cells from the sheet.
- Open the Page Layout tab and choose the Print Area option.
- From the Print Area menu, select the list icon.
- Click on the Set Print Area option.
- Now, the printing area has been selected and you can print easily.
- Press CTRL + P from the keyboard.
- In the Print Preview section, you can see the selected cells appear. Click on the Print button to print the selected cells only.
That’s it!
How to Print Specific Cells in Excel with Print Titles Command?
From the Page Setup menu, you will select the area for printing. You have to access the Print Titles feature to perform the steps given below:
- Open the Page Layout tab.
- Select the Print Titles option from the list.
- A new box will pop up in which you need to Enter the cell range given in the Print Area.
- Click on the Arrow icon.
- Choose the cell range you need to print from the Page Setup – Print Area box.
- Press ENTER key after the selection of the print area and then click on the arrow.
- Page Setup dialog box will appear.
- Click on the Print option from the menu.
- Press OK to save changes.
- Now, the print area has been set and your selected cells are also ready to print.
- Press CTRL + P and check the print preview.
All set!
To Wrap Up:
This post clearly defines how to print specific cells in Excel and you can try all of the above methods. You will always get the same results no matter which method you are applying. Practicing new skills can make you an expert.
