Oracle, Web, Script, SQLserver, Tips & Trick

October 12, 2012

Delete one or more blank separate rows on excel

Filed under: excel — sikathabis @ 6:39 am

For example if I have table like this on excel

NO Number

1 1000

2 2000

3 3000

4 4000

5 5000

6 6000

And selected 2 or 3 rows and delete all blank rows (shift cell up), you can manually delete that separate rows, but if the rows is thousand, you must change your way to do that.

NO Number

1 1000



4 4000


6 6000


NO Number

1 1000

4 4000

6 6000


How to do that ? simple ask mr. google, and you can find It.

  1. Firstable select All things that you want to delete blank rows
  2. Press F5 or CTRL-G or Choose Find & Select – Go To
  3. Click Special button
  4. Choose Blanks and then click Ok
  5. Now the blank rows has selected, to remove them, press Ctrl + (-) or you can find Delete Cells on the menu / ribbon

reference :


Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Create a free website or blog at



Learning is not a spectator sport

Connor McDonald's Oracle blog

Teknologi Pendidikan

Just another weblog


Jurnalisme Yang Dapat Dipercaya

Qey050489's Blog

Ayo Bangkit sobat..!!!!!

B. S. Totoraharjo

Orang Desa Yang Mencintai Desa dan Kebudayaannya

culturekitchen foodlab

New Food and Art in Yogyakarta

Wahyu Catur Wibowo

Musafir Dunia Maya

SQL.... Still Learning

My Reference on SQL Server


"A distance is getting far if your heart is impatient" -ean-


Street Photography is like a box of a chocolates, you're never know what you're gonna get - Thomas Leuthard -

Keluarga Andrivito

-- Andrivito's Journal --


This site is about Latest NEWS, Articles, Videos, Books, Course, Presentations, Tips & Tricks related to I.T Pro's

Gaurav Saxena

|| तत् त्वम् असि ||

Be a good Moeslim

Menuju Pribadi Muslim Sejati yang Bertaqwa


Manajemen Sholat, renungan spiritual, Teknologi Informasi

Pelangi di khatulistiwa....

Mari berbagi kebaikan, pengalaman dan senyum denganku


Ceritanya saya, Pikirannya saya, Hatinya saya

%d bloggers like this: