Skip to main content
Solved

Delete blank rows in excel


Forum|alt.badge.img+5

I have an excel sheet where there around 20 filled rows and rest of the rows are blank(Till the end of the sheet). I tried to delete the blank rows by using 'remove blank row' command but it is continuously loading since 15 mins and not getting executed so I stopped the task

Best answer by Raul Jaimes

@Rohan Tiwari 6713 

Kindly check the following post from AA team.

Another approach is copy only the content to a new spreadsheet ignoring the blank spaces.

HTH

Regards

View original
Did this topic help answer your question?

2 replies

Padmakumar
Forum|alt.badge.img+13
  • Navigator | Tier 3
  • 785 replies
  • March 22, 2023

Hi @Rohan Tiwari 6713 ,

 

Have you referred the below Article?

 

 


Raul Jaimes
Forum|alt.badge.img+9
  • Navigator | Tier 3
  • 494 replies
  • Answer
  • March 22, 2023

@Rohan Tiwari 6713 

Kindly check the following post from AA team.

Another approach is copy only the content to a new spreadsheet ignoring the blank spaces.

HTH

Regards


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings