Forum Discussion
Using OFFSET formula to create dynamic print area when cells contain formulas?
Good afternoon, Looking for help. I'm trying to set up a dynamic print area using OFFSET but, for the sheet I'm trying to print, all cells contain formulas so I've used IF and IFERROR to make th...
umasirhc , Since you have the data in an Excel table, you don't have to do any math calculate the dynamic range. Delete the rows that are empty. When you add new items, the calculations will automatically get filled in. You can select the entire Table and set the print area and it will automatically resize.