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
   James Godwin commented  ·  Oct 29, 2020  ·  Edit…  ·  Delete…

   Toggle (i.e. select the exact opposite) of all elements ticked in a data filter dropdown menu. When selecting multiple lines, you could toggle the selection, allowing you to see everything else instead - using just a single button click.

   Save Submitting...
   James Godwin supported this idea  ·  Oct 29, 2020