Blank rows or Blank cells is a problem we all inherit one time or another. This is very common when you try to import data from somewhere else (like a text file or a CSV file). Today we will learn a very simple trick to delete blank rows from excel spreadsheets.
- Select your data
- Press F5
This opens “Go to” dialog in Excel. Now hit on that “select” button. - From “select special” screen, select “Blanks” (shown aside)
Now, all the blank cells will be selected. - Just press CTRL and Minus sign (-)
- Select “shift cells up” or “entire row” as needed.
That is all. Now you have successfully removed blank rows.
Bonus tip:
If you are looking for keyboard short-cut for this, here it is. Press them in the same order once you select the cells.
- F5 ALT+s k Enter CTRL+ – u Enter
Remove Blank Rows in Excel – Video
Here is a short video showing this in action. Watch closely and get rid of those annoying blank cells.
4 Responses to “Office 2010 Contest Winners are here!!!”
I while ago I wrote a post on selecting a couple of names from a range via an UDF
I could have been handy.... especially because I didn't win.... lol
http://xlns.lamkamp.nl/?p=14
Sweet! I won! Thank you so much, Chandoo! I'm really speechless! I'll look out for an e-mail from you. Again, I really appreciate it, and I can't wait to fire it up!
Sincerely,
Tom "this one" 🙂
Thank You... Thank You... Thank You... 🙂
Hi,
Don't want to ruin your party.. 😉 but I noticed that when you sort the list A2:B11 (step 2), the RAND function re-calculates the numbers so that they are different and in mixed order again. I had to paste the whole area as values first and then sort to get it to work.
Wonder if the same happened to you because in your list at least Greg has a higher value than Tom 🙂