Afterward, click on the border and drag it like the following image.Let’s see how you can use this to print selected cells. Page Break Preview allows you to work with page breaks. In this method, we will use the Page Break Preview to print selected cells in Excel. Use Page Break Preview to Print Selected Cells Click “ Print” to print the selected cells.Ħ.Finally, you will see the preview area showing only the selected cells.Next, press Ctrl + P to see the print preview.Secondly, in the Name Box write Print_Area.Īs your print area has been set, the next time you print, this area will be selected by default.In this method, we will use this named range directly to print the selected cells in Excel. From now on every time you select the range, the Name Box will show Print_Area as an active cell. Yes, once you have defined the print area, Excel will know the range and name it as Print_Area. After you have set the area, select the cells which have been included in your print area and have a look towards the Name Box, you can see something interesting here.
WINDOWS PRINT SELECTION EXCEL HOW TO
So far we have seen how to set the print area. Set Print Area by Using Named Range in Excel Press Ctrl + P to see the print preview.ĥ. Here, you can check the print preview to see if it works.Finally, select OK and your selected cells will be set as Print Area.Next, the Page Setup dialog box will appear.Then, select the dialog box option from Page Setup.In the beginning, go to the Page Layout tab.For this method, you will need the Page Setup group. Here, we will use the Page Setup dialog box to print selected cells in Excel. Apply Page Setup Dialog Box to Print Specific Selection of Cells Finally, to check if it works press Ctrl + P and you will be able to see the print preview.Ĥ.You can directly print from here by clicking on Print, or just click on OK and save it for later.After that, you can check out the options you want to use from here on.Now you will see the Page Setup dialog box as follows. Once you select the print area hit Enter or click on the arrow of this dialog box.Then in the Page Setup – Print area dialog box, select the range of cells you want to print.In this dialog box, Enter your cell range in the Print area. After that, a new dialog box will emerge upon you (like the image below).Then, you will see a number of options there.First, click on Page Layout (if you are on a different tab).To accomplish the task, you are in need of the Print Titles feature. In this method we will select the area, to be defined as the print area in the Page Setup dialog. Print Selected Cells in Excel with Print Titles Command Click “ Print” to print the selected cells.ģ. After that, you will see the preview area showing only the selected cells.Click on the list icon of the Print Area.Secondly, on the Page Layout tab, you will see an option called Print Area.Firstly, select the area (cells) on the sheet.We are going to use the Print Area feature of that tab.
If you explore the Excel ribbon, you will find Page Layout. You can create your print area very easily. This method can be very handy if you print a selected area frequently. In this way, we will set up a printing area before triggering the print.
First, select the range of cells you want to print, let’s assume you want to print the Customer Name, Address and Email only.The first method is easy as the name suggests, you select your desired cells and then use the Print Option to print. We will use this Excel sheet to explain how to print selected cells.ġ. There are 4 columns, Customer Name, Email, Phone Number, and Credit Card Type. This excel sheet is about customer details and pursuing credit cards. 6 Effective Ways to Print Selected Cells in Excelįirst things first, let’s know about the Excel sheet first, which has been used as the example for this article.
0 kommentar(er)
