EdTech Help GuidesGS107 ExcelFilter data by color

Filter data by color

Instructions for the foreign box office assigment part of filtering data.

Select the data of "Total Foreign Box Office Sales"

  1. On the Home Tab click on the "Sort and Filter" icon.
  2. Click on "Sort Largest to Smallest"

Change the background color to yellow of third movie title

  1. Select the 5 movie titles.
  2. On the Home Tab click on the "Sort and Filter" icon and click on Filter.

 

  1. A drop down arrow will appear, click on it.
  2. On the "Sort" section click on "By color" box.
  3. Click on Cell Color, select the blue color.

 

0 Comments

Add your comment

E-Mail me when someone replies to this comment