See how to create a named formula with OFFSET & COUNTIF functions that defines a Print Area, and then insert the formula name into the Print Area Name. Create A Dynamic Print Area. See Name Manager 2007 (Define Name 2003)
Questions about Excel Magic Trick #215: Dynamic Print Range
Want more info about Excel Magic Trick #215: Dynamic Print Range?
Get free advice from education experts and Noodle community members.