Using range names in Excel allows you to quickly navigate to areas of your worksheet and makes formulas much easier to create. A range name is simply a name you assign to a range of data and is much ...

Microsoft Excel’s Name box is a powerful tool for its size. Use it to move around, create range names and even enter functions.

In Excel, Cell Names Spell Speed, Safety Give a cell a name, and your work will go faster and be more error-free.

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