Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

An Excel question

  1. Dec 31, 2007 #1
    Hi all,

    I have this excel problem: In a column, there are entries (can be characters or number), but there are also some blank cells. How could I remove all the blank cells so that the column is shorter.
    Here I attached an illustration

    Thanks for any comments

    Attached Files:

  2. jcsd
  3. Dec 31, 2007 #2
    Simple, select the cells to be removed. Use shift or control for multiple selections; go drop menu point "edit" and find function "delete". You will be prompted what to do with the remaining cells, to move up or left, etc.

  4. Dec 31, 2007 #3
    Thanks Andre.
    The thing is that in case there are hundreds of cells, to select blank cells is not simple.
    Blank cells appear randomly.
  5. Dec 31, 2007 #4
    To select just the blank cells, you can go to 'Edit', then 'Go To', click 'Special', and then select 'Blank Cells'. After that, delete them just like Andre said. You'll want to shift the remaining cells up, since you're removing blank cells in columns. Hope that helps.

  6. Jan 1, 2008 #5
    Thank you Josh, it seems I have solved the problem.
    Once again thanks Andre and Happy New Year to all of you
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook