Between the Sheets — Excel podcast episode 27: Dynamic ranges and print areas with the Offset function.

In partnership with Experts Exchange.

Excel’s Offset function, available in the last couple of versions for Windows and Mac, lets you create ranges that change location and size dynamically. In this video, we look at a few examples, then use the function to change the size of a print area on the fly.

Share:

Facebook
Twitter
Pinterest
LinkedIn
On Key

Related Posts

Get in touch