#HOW TO CHANGE PRINT AREA IN EXCEL 2016 PLUS#
#HOW TO CHANGE PRINT AREA IN EXCEL 2016 DOWNLOAD#

Follow these steps: Set your two ranges as your print area, as you have already done. You can make that dynamic also by using a similar process for the width. First, you could print multiple pages per sheet of paper. The height is defined by the COUNTA function, and we used 9 to define the width, since that is the number of columns in our range. The last two arguments define the size of the range. So, in our example, the reference was cell A1, we went down zero rows and over zero columns, which kept cell A1 as our starting point. The OFFSET function 'Returns the reference to a range that is a given number of rows and columns from a given reference'. Let's take a quick refresher on the OFFSET function. Now, whenever we add or remove items from our data range, the height of the print area will automatically adjust based on the number of items within column 'I'. Next, let's redefine the Print Area item to reference the DynPrint item we just entered: Now we have two items in the Name Manger: How do we create a process that will automatically adjust the height of the range based on the number of rows that contain data? Easy! We'll set up another item in the Name Manager and use the OFFSET function to dynamically define the height.ДЇirst we are going to create another item in the Name Manager, call it 'DynPrint' and insert the following formula in the 'Refers to' area: If I highlight the range I want to print, go to the Page Layout tab and choose Set Print Area, Excel will then define the print range that I want:ДЄnd notice that Excel has defined that range in the Name Manger:Д«ut if I add or remove rows of data, Excel will still print $A$1:$I$17. If I choose to Print this page, even though I only want to print the 17 rows with data, you can see that Excel wants to print all 51 rows: Now, you will see the spreadsheet divided into pages, which is how it will look when it is printed.

#HOW TO CHANGE PRINT AREA IN EXCEL 2016 PLUS#

Here I have a data range that has a header plus 50 rows for data: Go to the View tab and click the Page Layout button.

#HOW TO CHANGE PRINT AREA IN EXCEL 2016 DOWNLOAD#

If you get a preview, look for the download arrow in the upper right hand corner. Tip: To set multiple print areas, hold down the Ctrl key and click the areas you want to print.

You can download the file here and follow along. On the worksheet, select the cells that you want to define as the print area. In this tutorial we are going to discuss a process using the OFFSET function to automatically adjust your print area as you add or remove rows of data.

In the Preview window, click Margins.Often you may have a data range that you add or remove rows, and you need to keep redefining the print area manually.

From the File menu, select Print Preview.

Check Show margins, and then drag the margins to the desired size.

In the upper left, click the Office Button.

On the Page Layout tab, click Margins, and then.

Click Print Area, and choose Set Print Area.

Highlight the area of your spreadsheet that you want to print.

To do it, follow these steps: Step 1: Click.

Use the arrows to increase or decrease the margin sizes, or enter You can modify the printing settings to fit active worksheet to one page in Excel 2010/2013/2016 or later version.

On the Page Layout tab, click Margins, and then select.

Margins., adjust the values for each margin that you want

Choose a different pre-set option, or select Custom.

Under 'Settings', select the Normal Margins drop-down menu.

To adjust the page margins on a printed spreadsheet in Excel, you can use

Information here may no longer be accurate, and links may no longer be available or reliable.

This content has been archived, and is no longer maintained by Indiana University.

How to change print area in excel 2016