- NEW!
by Cyanotic Wasp on July 9th, 2009
Perhaps the best way to do what you want is to sort the entire table on the column that contains the gaps. That way the gaps will all be located in one place, and you can select and remove the entire group of rows.
If you want to return to the unsorted or "original" order, then you need a way to get back to that point, either by re-sorting on another column or by putting in a "placeholder" column where you number the existing rows from 1 to "n" and then sort on that later to get back to this order.
There are also macros available to wipe out entire rows based on the contents of a cell, but these can be somewhat dangerous to apply if you don't know exactly how they work.
Is anyone on here experienced with Microsoft Excel? I need a favor, please.
by NiCkIzBacK on August 24th, 2011
| 1 person likes this
No matter what cells I select, the freeze panes option always selects the first 15 rows to freeze. How do I fix this in Excel 2010?
by Nickname on October 8th, 2011
| 1 person likes this
I need a formula in Excel that does the following..
If the value in cell A1=X, then multiply cell B1 by 5..if A1=Y, then multiply B1 by 8.
by leslie2413 on September 1st, 2011
| 2 people like this
When I sort a list in Excel it sorts A to Z then A to Z again, not the same items, just half of it on top and half on bottom. Why?
by AndaleTheGreat on August 13th, 2011
| 1 person likes this
What are examples of Spreadsheet application software?
by tinmanEvil on August 13th, 2011
| 1 person likes this
You're reading Can I eliminate gaps in a column of data in microsoft excel?
Your favorite Q&A site is on Facebook! Become a fan to connect with the ever-growing community of Answerbaggers, share your thoughts and find out what Answerbag's up to next!
Comments