Forum Discussion
freeze a section of Excel
I have two spreadsheets right next to each other on Excel. I am trying to add rows to the first one without consequently adding rows to the other. Is there a way to do this easily? Thanks!
Hey Sarah-
It sounds like you have two windows (views) open that reference the same worksheet. I think you want to insert cells not rows. Refer to the Insert Cells portion of this support article:
https://support.office.com/en-us/article/insert-one-or-more-rows-columns-or-cells-in-excel-2016-for-mac-95f00e00-5f58-43f5-971b-7a6550030556