It means both ‘Sales’ and ‘SALES’ will work as the similar named range of cells. These are the indicators of rows and columns in Excel. You cannot name a range with only ‘R’ or ‘C’.The names cannot be with the cell addresses (e.g: C1, R1C1).No space character is allowed to use in the name of a range.We can have a glance at those rules to keep them in memory while defining names for the selected ranges. There are some conventions for naming a range of cells. Some Rules to Name a Range of Excel Cells Excel allows a named range to be dynamic with additional inputs from the user.The named range makes a formula dynamic which means if we define a formula with a name, we can also use that named range to perform calculative operations instead of typing a combined and huge formula.The named range is not limited to use in a single worksheet only. Once created, the named range can be used in any of the worksheets in a workbook.Due to the use of a named range, we don’t have to go back to our dataset every time while entering a range of cells.While using the named range in a formula or function, we can avoid using cell references.

Let’s go through the following points that might persuade us to use a named range frequently in Excel spreadsheets. While dealing with large formulas, the named range is a handy operator there to input the specific range of cells with ease. We could’ve typed the formula with “=SUM(B3:B7)”, but we have used the named range Data instead here. In the output Cell D6, we’ve performed a simple sum of all values present in that named range. The range of cells, B3:B7 has been named with Data. The following is an example of using a named range. A named range can be used in a function or a formula instead of selecting the corresponding range of cells manually. A named range is a range of cells or an array that is assigned with a user-defined name.

How to enable editing in excel