title: Invert filter selection in Excel
body: <p>I'm asking a question that I plan to answer so I can document this problem in a lasting way. More than happy for others to pitch in with other suggestions / corrections.</p>
  
  <p>I often have an issue in Excel where I'm using filters and then want to invert the selection i.e. unpick all the items that have been picked and pick all the items that are not currently picked. For example, see screenshots below:</p>
  
  <p>There's no easy way to do this (that I know of!) other than clicking through the list, which laborious and error prone. How can we get this functionality automated in Excel?</p>
  
  <p>Before:</p>
  
  <p><a href="https://i.stack.imgur.com/yOFVq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/yOFVq.png" alt="Initial selection"></a></p>
  
  <p>After:</p>
  
  <p><a href="https://i.stack.imgur.com/8Qmrk.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8Qmrk.png" alt="Inverted selection"></a></p>