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

Now certified in AI Ethics

Just earned my third AI certification: AI+ Ethics, from AI Certs. Now offering training in ethics issues, including transparency, accountability, privacy, mitigating bias and compliance

Earned another AI certification

I just earned the AI+ Executive certification from AI Certs. This is to assist and train companies in developing AI strategies, governance and risk management,

Get in touch

AI Workshop Inquiry/Booking