Forum Discussion
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...
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...
As a warning, please always press F2 (to shift to Edit mode) before you edit the range of your defined name!