This seems like such an easy, basic thing--but I can't for the life of me figure out how to do it. I just want to copy and paste cells from an Excel sheet into a SharePoint Excel WITHOUT overwriting the data already in the SharePoint. I just want it to create a new cell/row and move the existing cells/rows down.
I tried using "Insert Cells and Shift Down"--but that just creates one new, empty cell. It doesn't paste the rows/cells on the clipboard.
I'm driving myself insane. Do I really need to add rows FIRST before I copy and paste?