Forum Discussion

Sarah Watts's avatar
Sarah Watts
Copper Contributor
Aug 01, 2018

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!

1 Reply

  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor

    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