How to change print area in excel how to#

After you have set the area, select the cells which have been included into your print area and have a look towards the Name Box, you can see something interesting here.

How to change print area in excel how to#

So far we have seen how to set the print area. Now you can directly print from here clicking on Print, or just click on OK and save it for later. You can check out the options you want to use from here on. Now you will see the Page Setup dialog box is as follows Once you select the print area hit Enter or click on the arrow of this dialog box.Or, Click on the arrow and 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 at the Print area A new dialog box will emerge upon you (as like the image below).You will see a number of options there.First click on Page Layout (if you are on a different tab).To accomplish the task, again you are in need of Page Layout feature.

In this method we will select the area, to be defined as the print area in the Page Setup dialog.

Now on the Page Layout tab, you will see an option called Print Area.

We are going to use a feature of that tab. If you explore Excel ribbon, you will find Page Layout. You can create your print area very easily. For initializing a certain area, you have two options. This method can be very handy, if you print a selected area frequently. In this way, we will set a printing area before triggering the print. Method 2: Define the Printing Area in Excel Now you will see the preview area is showing only the selected cells.

Now on the Excel Print Settings option click on the list icon of print area settings.

Now, Click on File (on the top left of Microsoft Excel) and then select Print or simply press Ctrl+P.

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 print. Further Readings 2 Ways to Print Selected Cells in Excel Method 1: Printing a Specific Selection of Cells in Excel