To filter the AccountReps table in Excel to display all clients except those in the southeast, follow these steps:
1. Click on the drop-down arrow next to the column header for the region (e.g., Southeast) in the AccountReps table to display the filter arrows.
2. Click on the filter arrow for the region column and uncheck the box next to Southeast to exclude these clients from the table.
3. Click OK or Apply to apply the filter and display only the clients in other parts of the country.
You should now see a filtered view of the AccountReps table showing all clients except those in the southeast region.
11. As a contrast, Bao also wants to list the clients in other parts of the country. In the AccountReps table, display the filter arrows, and then filter the table to display all clients except those in the southeast. (Hint: Use the Filter command on the Sort & Filter menu to display the filter arrows.) How to do in excel
1 answer