Forum Discussion
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
- GI20211028Copper Contributor
to add to this, I need to be "Temporary Sheet View" as this is a shared excel workbook.