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

Then you can use those range names in your formulas or macros to replace values or cell references, or to quickly and more easily navigate through your spreadsheets and workbooks.

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.

Using range names in Excel allows you to quickly navigate to areas of your worksheet and makes formulas much easier to create.

Press F10, and small letters appear over each ribbon tab and quick access toolbar item. Alt+H takes you to the Home tab, Alt+N to Insert, and so on. Once in a tab, additional letters appear for ...

Handling Spaces in Named Ranges One important consideration when creating named ranges in Excel is that spaces are not allowed in the range names.

How to Change a Range in Microsoft Excel. When you copy a formula, referenced ranges automatically adjust according to the formula's new position unless the ranges use absolute references.

Open Microsoft Excel, then click "File" and open the document containing the named range you want to delete. Click the "Formulas" tab and click "Name Manager" in the Defined Names group.

Use Delimiters in Excel One of the most straightforward ways to separate first and last names is by using delimiters in Excel. A delimiter is a character that separates different parts of text data.