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...
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)