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.

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.

How to Add the Difference Range In Excel. The simplest way to add cells in Microsoft Excel is using the plus operator, such as "=A1+A2," but that method fails when adding different ranges. Ranges ...