Share via

Removing Empty Cells in a Column- Compact Data

Anonymous
2010-09-14T21:07:37+00:00

I have a column of numbers interspersed with empty cells. How can I compact the numeric data, or remove the empty cells without removing rows in the spreadsheet?

Thanks

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2010-09-14T21:11:32+00:00

    Hi,

    One way. Select this column of numbers and then tap F5 - Special - select blanks - OK

    Now right click any selected blank cell - delete - in the popup select 'shift cells up' - OK

    If this post answers your question, please mark it as the Answer.

    Mike H

    3 people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2010-09-14T21:45:13+00:00

    Hi,

    2007 added Filters.  Click on Data in the Ribbon then highlight your column headers and click the Filter button.  Dropdowns on each column header let you choose how to filter your data.  In the column in question, simply uncheck the (blanks) box.

    If you want to work with VBA, you can write a macro to do this, alternatively, without any filters.

    0 comments