Forum Discussion

GI20211028's avatar
GI20211028
Copper Contributor
Oct 28, 2021

PLEASE HELP! When in sheet view - inserting a row

Hello! 

I am working on a shared document and love the sheet view feature! However, I notice when I am I in sheet view, if i need to insert data  the next immediate row it brings me to 19,500. For example, I am in sheet view, I filtered on certain groups that are assigned to me. My assigned group is in row 5 and 12. I need to add another row but the next available row is 19,500, when really it is 35. I insert that row and then unfilter. The data I inserted is in 19,500. Other's then also see the row in 19,500 there is a big break in rows. The last row (when unfiltered and in default) view is 34. When I am in my view and I try to INSERT a row, a warning comes up that the operation I am about to perform affects a large # of cells and make take time, I click OK and then it says there is not enough memory. What are my options to insert a row? Is my only option to insert on row 19,500, copy, unfilter then paste it into row 35? I would imagine there is another approach, please help!!! appreciate it!!!! = )

1 Reply

  • GI20211028's avatar
    GI20211028
    Copper Contributor

    to add to this, I need to be "Temporary Sheet View" as this is a shared excel workbook.