My feedback

1. Invert Filter Selection

   285 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   51 comments  ·  Excel for Windows (Desktop Application) » Tables, Sorting and Filtering  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Accepting Votes  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

   Thanks for this suggestion. We agree it would be a nice improvement. We will consider this for a future update.

   Steve [Microsoft Excel]

   An error occurred while saving the comment
   ANURAG SINGH commented  ·  Dec 24, 2019  ·  Edit…  ·  Delete…

   Hi,
   HERE I M TO HELP YOU
   FILTER THAT ROWS AND THEN COLOR IT (YELLOW, RED OR YOUR FAVORITE COLOR)
   THEN REMOVE FILTER BY PRESSING (CTRL+SHIFT+L) THEN AGAIN TURN ON FILTER BY PRESSING (CTRL+SHIFT+L) AND IN ANY COLUMN AND SELECT FILTER BY COLOR IN CELL DROP DOWN MENU THEN SELECT "NO FILL"

   Save Submitting...