Jump to content

Deconstruct range names


Recommended Posts

Deconstruct range names

Naming a selected cell or block of cells is handy because then you don't have to remember the cell address when you want to refer to the range in a formula.

However, there are times when you may need to determine a range name's address. For those times, Excel offers several ways to determine the cells to which a range name refers.

• Press [Ctrl]G, enter the range name, and press [Enter]. Then manually inspect where Excel moved the cursor.

• Go to Insert | Name | Define, and click the range name. Excel displays the addresses of the cells currently associated with that name.

• Enter =CELL("row",<rangename>), replacing <rangename> with the name you want to deconstruct. This function returns the row number of the named range. If the range spans two or more rows, the function returns the topmost row number. Use =CELL("col",<rangename>) to determine the range address' column component. If the named range spans two or more columns, the function returns the leftmost column. Note that this function returns the column number, not the letter.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...