- 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.
by HoboJoe on July 8th, 2009
You can hide them too. Yes, you can eliminate the unneeded columns by clicking the top and pressing delete.
by Brian I on July 9th, 2009
Go to the Data... Filter... Auto-Filter menu and then click om the drop-down arrowhead in the appropriate column and select "Non-Blanks".
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
In Microsoft Excel I need 25 hours to be displayed but when I enter 25:15 (hours:minute) it shows 1:15. Any ideas on how to fix this?
by One mans opinion on August 10th, 2011
| 1 person likes this
How do I identify duplicate rows in Excel 2003? (In plain english please.)
by Yeahwell... on September 16th, 2011
| 1 person likes this
Could someone give me a good definition of VLOOKUP in Excel?
by slimNanny 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