Named ranges aren't just for formulas. Here are two ways you can use named ranges to create shortcuts for quick navigation in a Microsoft Excel workbook.

Why You Should Always Name Ranges in Excel You might be familiar with bookmarks in Microsoft Word, which are invisible way-points in specified locations of a document that you can jump to whenever ...

Working with ranges in Excel is a fast and simple way to identify, define, or refer to a single cell, a range (or group) of cells, a specific or constant value, or a formula. Then you can use ...

How to use Name to create a named range in Excel On Excel’s Formula tab, the options in the Defined Names group help you name a range. To go to a range, simply select it from the dropdown.

Cutting and pasting ranges of cells is a common operation in Excel, and Microsoft's Visual Basic offers streamlined functionality to easily automate the process.