title: Script in google sheet to clear, but not remove filter
body: <p>I am completely new in writing scripts for google sheets, so I was hoping some of you could help/guide me a little bit.</p>
  
  <p>So Ideally, I want a script to clear (not remove) ALL filters in my sheet. This is, however, complicated for me to do (If some of you have such a script, I would LOVE to see it :) ) </p>
  
  <p>Instead, I made this one (Used recorder):</p>
  
  <pre><code>function Clear_Filter() {
    var spreadsheet = SpreadsheetApp.getActive();
    spreadsheet.getRange('A5').activate();
    spreadsheet.getActiveSheet().getFilter().removeColumnFilterCriteria(1);
    spreadsheet.getRange('B5').activate();
    spreadsheet.getActiveSheet().getFilter().removeColumnFilterCriteria(2);
    spreadsheet.getRange('C5').activate();
    spreadsheet.getActiveSheet().getFilter().removeColumnFilterCriteria(3);
    spreadsheet.getRange('G5').activate();
    spreadsheet.getActiveSheet().getFilter().removeColumnFilterCriteria(7);
    spreadsheet.getRange('J5').activate();
    spreadsheet.getActiveSheet().getFilter().removeColumnFilterCriteria(10);
    spreadsheet.getRange('M5').activate();
    spreadsheet.getActiveSheet().getFilter().removeColumnFilterCriteria(13);
  };
  </code></pre>
  
  <p>So my filter is set in Row 5. First I made the above for all columns (I had 20), but the problem is, that the code is very slow :( So now I am using the columns, that I use the most, when filtering, but the code is still slow. Well the worst thing is, that the code is running one column at a time (which we see in the code), and when the code is finish, I end up in the last column.</p>
  
  <p>Can I do something? I dont want my sheet window keep turning right, when I run the code, and then end up in column M. </p>
  
  <p>I will appreciate any help!
  Thanks</p>