Explainry Tutorials to Expert in IT

Filter by color in Excel

See first: How to filter in Excel?

To filter by color, execute the following steps:

1- Select the data and press Alt + A + T.

Arrows will appear in columns’ header.

2- After clicking on an arrow, filter menu will open.

3- On the filter menu, press I or go to the Filter by Color option and select your required color. Click OK or Press Enter.

4- Result. Excel will show selected colored data only.

How to remove the color filter?

To remove the color filter:

1- Click on the arrow showing filter sign.

2- Click on the tick mark in the selected color area.

For more detail, visit Microsoft Office website.

Next Lesson: Number and Text Filter

Copyright © 2016 - 2020 Explainry.com | All Rights Reserved