Data Cleaning

We have a dataset of approx. 20 variables (columns) with around 800 records (rows). We need to get rid of entire rows of data associated with a certain variable. To make it clear, let's say for these purposes gender. If variable 18, called Variable_Gender = female [instead of male], we want to delete the entire record b/c we are not interested for this analysis in females, just males -- so NOT just the CELL w/ female as gender, but ALL of the data associated with that record - in other words, the entire ROW.

It doesn't appear that we can do this by using the delete function under the file menu. Can you help?

If you use Autofilter to filter for the data you want to delete and then select the visible rows (ie with your mouse as usual) and go Edit>Delete... you should be met with a dialog which contains the option to delete entire rows.