How to delete empty cells?


November 7th, 2013 by ya tan ya tan

I have an excel file per following attachment. I would like to move non-blank cells to fill starting from the left most cell(column 1). How can I do that?

1 2 3 4 5 6
NDM CPOTH

NDM CPOTH
KPC NDM
OXA181 OXA232 OXA OX48
NDM
NDM
OX48

For Example, the tabulation shall become like the following.

NDM CPOTH
KPC NDM CPOTH

Regards

ya tan

2 Responses to “How to delete empty cells?”

  1. BenneTan BenneTan Says:

    hi ya tan. i attached an eg since your sample alignment is all skewed. could you help us understand how you derived at the answer? removing the blanks from A1:C1, & E1 would give me the results on the right table of my file. but how does the “KPC” go to H2 of my file? if it’s because C3 is a blank, isn’t C1:C2 blanks too? shouldn’t it go to the first row?

    http://wp.me/a2cP0f-x8

  2. BenneTan BenneTan Says:

    as per your sample file, you can delete I2:O10 first so that it’s not confusing. then:
    1. select A3:G10

    2. press F5 or CTRL + G

    3. Click on Special

    4. select Blanks & OK

    5. go to Home tab -> Delete -> Delete Cells. shortcut is CTRL + the minus key.

    6. Choose Shift cells left. press OK & you’re done.

Leave a Reply

You must be logged in to post a comment.

s2Member®