SOLVED

Small but annoying issue (Excel Online)

%3CLINGO-SUB%20id%3D%22lingo-sub-3327325%22%20slang%3D%22en-US%22%3ESmall%20but%20annoying%20issue%20(Excel%20Online)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3327325%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20never%20had%20this%20issue%20before%20while%20using%20excel%20online.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20started%20a%20week%20ago%2C%20can't%20recall%20exactly%20what%20was%20being%20done%20to%20the%20document%2C%20but%20it%20only%20happens%20with%20this%20entire%20worksheet%20no%20matter%20the%20tab.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20%22phantom%22%20row%20appeared%20in%20between%20the%20upper%20left%20corner%20and%20row%20number%201%20(Shown%20in%20picture)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20not%20a%20big%20deal%20but%20it%20becomes%20annoying%20the%20further%20down%20you%20go%2C%20messing%20with%20the%20alignment.%20I'm%20just%20a%20beginner%20on%20this%20program%2C%20could%20really%20use%20some%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Awayus_0-1651775332988.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F369550iB67AAECD50226306%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Awayus_0-1651775332988.png%22%20alt%3D%22Awayus_0-1651775332988.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20bit%20more%20info%3A%3C%2FP%3E%3CP%3E-%20Not%20frozen%20rows%3C%2FP%3E%3CP%3E-%20You%20can%20right%20or%20left%20click%20that%20empty%20space%2C%20but%20nothing%20comes%20up%3C%2FP%3E%3CP%3E-%20No%20hidden%20rows%20nor%20columns.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3327325%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3353572%22%20slang%3D%22en-US%22%3ERe%3A%20Small%20but%20annoying%20issue%20(Excel%20Online)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3353572%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1382272%22%20target%3D%22_blank%22%3E%40Awayus%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20having%20this%20same%20issue.%26nbsp%3B%20It%20only%20happens%20when%20I%20paste.%26nbsp%3B%20The%20only%20way%20I've%20found%20to%20%22fix%22%20it%20is%20to%20close%20the%20workbook%20and%20re-open.%26nbsp%3B%20Following%20for%20updates.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3358406%22%20slang%3D%22en-US%22%3ERe%3A%20Small%20but%20annoying%20issue%20(Excel%20Online)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3358406%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1382272%22%20target%3D%22_blank%22%3E%40Awayus%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20found%20a%20new%20fix%20for%20my%20pasting%20issue%20yesterday%20-%20if%20I%20use%20ctrl%2Bshift%2Bv%20(instead%20of%20ctrl%2Bv)%2C%20the%20misalignment%20doesn't%20happen%2C%20and%20will%20even%20fix%20it%20if%20I%20used%20ctrl%2Bv%20first.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3358086%22%20slang%3D%22en-US%22%3ERe%3A%20Small%20but%20annoying%20issue%20(Excel%20Online)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3358086%22%20slang%3D%22en-US%22%3EThat%20worked%20for%20a%20while%20but%20it%20suddenly%20stopped%20working.%3CBR%20%2F%3E%3CBR%20%2F%3EOddly%20enough%20it%20did%20start%20happening%20after%20I've%20pasted%20something%20into%20a%20merged%20cell%2C%20sad%20but%20glad%20I'm%20not%20alone%20in%20this.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3360484%22%20slang%3D%22en-US%22%3ERe%3A%20Small%20but%20annoying%20issue%20(Excel%20Online)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3360484%22%20slang%3D%22en-US%22%3EAmazing%20finding%2C%20this%20actually%20fixed%20my%20issue.%20I%20copied%20a%20random%20cell%20and%20pasted%20on%20another%20random%20spot%20to%20be%20specific%3B%20I've%20copied%20cell%20A2851%2C%20and%2C%20paste%20it%20using%20ctrl%2Bshift%2Bv%20in%20cell%20A3005%2C%20and%20it%20aligned%20all%20the%20rows.%20(Cell%20A2851%20had%20data%20on%20it%2C%20cell%20A3005%20was%20empty).%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3368684%22%20slang%3D%22en-US%22%3ERe%3A%20Small%20but%20annoying%20issue%20(Excel%20Online)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3368684%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1382272%22%20target%3D%22_blank%22%3E%40Awayus%3C%2FA%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EFollow%20these%20steps%3A%3C%2FSPAN%3E%3C%2FP%3E%3COL%3E%3CLI%3E%3CP%3E%3CSPAN%3EHighlight%20the%20first%20blank%20row%20below%20your%20data%20(i.e.%20the%20first%20row%20you%20want%20to%20delete)%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3E%3CSPAN%3EHit%20the%20ctrl%20%2B%20shift%20%2B%20down%20arrow%20to%20highlight%20all%20of%20the%20rows%20below%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3E%3CSPAN%3ERight-click%20the%20row%20labels%20(where%20each%20row's%20number%20is%20shown)%20on%20the%20left%20side%20and%20select%20%22delete%22%20in%20order%20to%20delete%20all%20of%20these%20rows.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3E%3CSPAN%3EHit%20ctrl%20%2B%20home%20in%20order%20to%20go%20back%20to%20the%20top%20of%20the%20document.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3E%3CSPAN%3EHit%20ctrl%20%2B%20s%20in%20order%20to%20save%20the%20document.%20As%20it%20saves%2C%20you%20should%20see%20the%20scroll%20bar%20on%20the%20right%20side%20change%2C%20indicating%20that%20the%20blank%20rows%20are%20disappearing.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%3CSPAN%3ERegards%2C%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ESuyash%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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.

 

Awayus_0-1651775332988.png

 

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

@Awayus 

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.

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.
best response confirmed by Awayus (New Contributor)
Solution

@Awayus 

I 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. 

Amazing finding, this actually fixed my issue. I copied a random cell and pasted on another random spot to be specific; I've copied cell A2851, and, paste it using ctrl+shift+v in cell A3005, and it aligned all the rows. (Cell A2851 had data on it, cell A3005 was empty).

 

Hi @Awayus 

 

Follow these steps:

  1. Highlight the first blank row below your data (i.e. the first row you want to delete)

  2. Hit the ctrl + shift + down arrow to highlight all of the rows below

  3. 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.

  4. Hit ctrl + home in order to go back to the top of the document.

  5. 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