Forum Discussion

janaki223's avatar
janaki223
Copper Contributor
Aug 14, 2019

EXTENDING A NAMED RANGE

I have a range of cells in a sheet that is named, and formulas in a different sheet refer to that range.   I inserted a row into the middle of that range (had an entry to add), and now one row at t...
excel
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Aug 14, 2019

janaki223

 

Hi,

 

I've tested that by naming a range and add a row in the middle of that range, but the range is automatically expanded!

The case that the range is not automatically expanded is if you add the row at the top or bottom.

Please check the range again.

 

However, if that somehow happens to you, you don't have to redefine the range again, just click Ctrl+F3 to access the Name Manager, from there you can edit the defined names.

 

Regards

  • janaki223's avatar
    janaki223
    Copper Contributor
    Aug 14, 2019

    Haytham Amairah 

     

    I think what happened was that I added the row at the bottom, and then resorted based on alphabet order of the name in the first column.  so, I would have been better off, I guess, inserting the data into the middle.

     

    thanks for the tip on using Ctrl+F3.  that sounds like exactly what I need (why isn't that easier to find??  I didn't see it anywhere in the help pages...

    • Twifoo's avatar
      Twifoo
      Silver Contributor
      Aug 14, 2019
      As a warning, please always press F2 (to shift to Edit mode) before you edit the range of your defined name!
    • Haytham Amairah's avatar
      Haytham Amairah
      Silver Contributor
      Aug 14, 2019

      janaki223

       

      You can even find it under the Formulas tab as the defined names have a complete group in the tab:

Resources