Question
Filter the Participants table to display only records with a value of Atlanta in the City field. How to do in excel
Answers
Answered by
GPT 3.5
To filter the Participants table in Excel to display only records with a value of Atlanta in the City field, you can follow these steps:
1. Click on any cell within the Participants table.
2. Go to the Data tab on the Excel ribbon.
3. Click on the Filter button. This will add filter arrows to the top row of each column in the table.
4. Click on the filter arrow in the City column.
5. Deselect the (Select All) option and then select Atlanta from the list of cities.
6. Click OK or press Enter to apply the filter.
Now, only the records with Atlanta in the City field will be displayed in the table.
1. Click on any cell within the Participants table.
2. Go to the Data tab on the Excel ribbon.
3. Click on the Filter button. This will add filter arrows to the top row of each column in the table.
4. Click on the filter arrow in the City column.
5. Deselect the (Select All) option and then select Atlanta from the list of cities.
6. Click OK or press Enter to apply the filter.
Now, only the records with Atlanta in the City field will be displayed in the table.
There are no human answers yet. A form for humans to post answers is coming very soon!