May 05 2022 11:31 AM
Hello!
I've never had this issue before while using excel online.
It started a week ago, can't recall exactly what was being done to the document, but it only happens with this entire worksheet no matter the tab.
A "phantom" row appeared in between the upper left corner and row number 1 (Shown in picture)
It is not a big deal but it becomes annoying the further down you go, messing with the alignment. I'm just a beginner on this program, could really use some help.
A bit more info:
- Not frozen rows
- You can right or left click that empty space, but nothing comes up
- No hidden rows nor columns.
May 10 2022 01:06 PM
I'm having this same issue. It only happens when I paste. The only way I've found to "fix" it is to close the workbook and re-open. Following for updates.
May 11 2022 07:48 AM
May 11 2022 08:12 AM
SolutionI found a new fix for my pasting issue yesterday - if I use ctrl+shift+v (instead of ctrl+v), the misalignment doesn't happen, and will even fix it if I used ctrl+v first.
May 11 2022 12:51 PM
May 12 2022 11:07 PM
Hi @Awayus
Follow these steps:
Highlight the first blank row below your data (i.e. the first row you want to delete)
Hit the ctrl + shift + down arrow to highlight all of the rows below
Right-click the row labels (where each row's number is shown) on the left side and select "delete" in order to delete all of these rows.
Hit ctrl + home in order to go back to the top of the document.
Hit ctrl + s in order to save the document. As it saves, you should see the scroll bar on the right side change, indicating that the blank rows are disappearing.
Regards,
Suyash
May 11 2022 08:12 AM
SolutionI found a new fix for my pasting issue yesterday - if I use ctrl+shift+v (instead of ctrl+v), the misalignment doesn't happen, and will even fix it if I used ctrl+v first.