Forum Discussion
Something is not right!
So I'm stuck. I'm not that great with excel so I'm learning shortcuts from google. I need to clean some data. I need to delete all rows that have blank data in certain fields(Column headings). I have found the short cut to do this. One of the headings also require me to delete any record where market cap is less than or equal to zero. I found a way to delete all the zeros from that column. However, it made all the cells that had zeros turn to blanks. I figure I could use the same short cut as before to delete all the blanks but it won't do it. its like it doesn't recognize them as blanks. The only option I see now is to go through all the data (4k plus) and delete each blank row manually.
2 Replies
You could help us help you further, in addition to or beyond the suggestions you've received from m_tarler , by showing us the actual workbook (just drag and drop into your next reply). Or an image--but the actual workbook is far more meaningful. If it's a lot of confidential information, then a more complete verbal description. And if you can describe the source(s) of the data, how it gets into your spreadsheet in the first place, and maybe a word or two about the purpose or goal you have in mind for using this data once it's cleaned up.
I don't know what 'trick'/'shortcut' you used in either case. There is a difference between a BLANK cell and a cell with no value in it, so that might be what you are experiencing.
As for a way to do what you need you can either format as a table (Home -> Format as Table) or just add the quick filter buttons onto the table ( Date -> Filter). Then filter the data to only show blank and/or zero's and then you can delete those rows. Then clear the filters (Data -> Sort&Filter -> Clear)
