Find solution
How to automatically delete certain rows in Excel?

In excel I want to delete rows from 1 to 100 containing empty cells. i.e. say alternate rows or selective rows containing no data. How to do it by shortcut. Now Iam deleting by selecting each row and doing which is time consuming. Kindly help

  • Answer:

    Sort your spreadsheet by any column that contains data which is non-existent in the rows you want to delete. Your empty rows will bunch-up together; select them with "shift" and push delete. After that, sort again by whatever column you had it sorted by originally.

Ravichandran at Answerbag.com Visit the source

Was this solution helpful to you?

Other answers

If it is alternate rows you need to hold down ctrl and select every other row - then delete. But do it in chunks cause if you go for too big a selection it will just stop. Similarly if there are consecutive rows you can hold down shift and highlight them for deletion.

Piggle

you can left click on the first colume (1) hold and drag down to 100 then right click on the highlighted area and delete columes!

Leo26

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.