Forum Discussion

Awayus's avatar
Awayus
Copper Contributor
May 05, 2022
Solved

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 workshe...
excel
Excel for web
training
  • NCOX5909's avatar
    NCOX5909
    May 11, 2022

    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. 

suyashthomson's avatar
suyashthomson
Copper Contributor
May 13, 2022

 

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

Resources