Forum Discussion

Claire100's avatar
Claire100
Copper Contributor
Jul 21, 2022

named areas

My spreadsheet has a number of different named areas each of which is one row by a number of columns.  If I insert a row in the middle of these different named areas, the name remains attached to its original row number and does not move down with the row to which it is attached.  How do I ensure that names move correctly?

excel

1 Reply

  • mtarler's avatar
    mtarler
    Silver Contributor
    Jul 21, 2022
    It may be the way you are defining those Named areas. I tested it and it works fine for me.