Tips for automatically adjusting Excel print areas

tips for automatically adjusting Excel print areas

Tip: Print area that can be resized automatically

Operation Steps:

1, select area-page layout-Set the print area.

2. Formula-Name Manager, print select Print_Area, and then enter the following formula in the text box below:

=offset (sheet1! $A,,, COUNTA (sheet1! $A: $A), COUNTA (sheet1!$1:$1))

Introduction to Formulas:

COUNTA (sheet1! $A: $A): Statistics on how many rows

COUNTA (sheet1!$1:$1): How many columns are counted

OFFSET (A1,,, number of rows, number of columns): Generates a dynamic region based on the number of rows and columns at A1 Vertex

Effect as shown in the dynamic diagram below, the print area is automatically resized after the new column or row is added (note the dashed change)