Excel Q, cause I have no clue how it works

[N-OS X-tasy!]

datbeme wrote:
1. Select the range of data, including the headers.

2. Insert > Table

3. "Create Table" dialog will appear confirming range, such as: =$A$1:$D$35

4. Make sure "My table has headers" is selected and click OK.

5. Click on the drop down arrow in the First or Last Name column and deselect "blanks"

That will filter them out.

If you want to delete them forever, you can do the opposite. In other words, deselect all the boxes, then select "blanks" only to see just those rows, and then you can manually delete them. Remove the filter and you'll have all the rows with first and last name.

This will also work without performing steps 2-4.