Forum Discussion
Small but annoying issue (Excel Online)
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.
5 Replies
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
- That worked for a while but it suddenly stopped working.
Oddly enough it did start happening after I've pasted something into a merged cell, sad but glad I'm not alone in this.
