How to create and edit named ranges in Excel?

January 18, 2022
529 Views 0

You can easily locate the cells or cell ranges and follow your spreadsheets with named ranges. Here are steps to create and edit named ranges.

lTo create a named range

1. Navigate to the Formulas tab and click on Name Manager, whose shortcut key is Ctrl+F3. In the pop-up box, click New to define a new named range. Then you can enter name for the range, set the scope (Workbook or Sheet), add comments and set the applied range of cells. For instance, enter Nov_Sales at Name and it refers to B2:B6. Click OK and the named range is created.

1.gif

2. Alternatively, highlight the desired range of cells. In the Name Box, enter the desired name for the range, for example, Nov_Expenses, and press Enter. Now, the named range is defined and you can click on the Name Box and select the desired option to locate the range quickly.

2.gif


lTo edit the named range

1. To edit the named range, click on the Name Manager button again, select the desired name and click Edit. In the pop-up dialog box, you can alter the details of the named range; for example, change the applied range from C2:C6 to C2:C5, and click OK.

3.gif

2. If you want to delete the named range, select the desired one and click Delete>OK.

4.gif

Anyway, WPS Office suite makes your work easy. Free download WPS Office for PC, Mobile, Windows, Mac, Android, and iOS online.


Was this helpful?