Microsoft Excel allows you to assign names to any cell range using its "Define Name" utility, assessable via the right-click menu.

However, your Excel 2013 spreadsheet might also use named ranges that never change unless you manually adjust them. Changing these ranges apply to all formulas that use the named range.

By default, Microsoft Excel's cells are named by their column-row references, like A1 or B2. However, you can assign a more specific name to a cell or range of cells to improve navigation, make ...

Why Excel's Named Ranges Are Useful A named range is an Excel feature that lets you assign a meaningful name to a specific cell or a group of cells within a spreadsheet.

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

Excel tables have many benefits that regular spreadsheets lack. The biggest is the option to use data from multiple tables to create queries and reports.