F3 – Paste Defined Names If you're not using named ranges in your Excel spreadsheets, you're missing out on something useful. Named ranges make formulas far more readable and manageable.

Excel's spill range is a product of using dynamic array functions. Learn how the spill range fulfills these functions.