title: How can I restrict an AutoFilter in Excel Interop to only act on the rows in one column?
body: <p>I want to allow filtering on the values in one column (A, or 1), from a specific row (6). I can provide filters for <em>all</em> the columns on a row like so:</p>
  
  <pre><code>Range sixthRow = (Range)_xlSheet.Rows[6];
  sixthRow.AutoFilter(1,
          Type.Missing,
          XlAutoFilterOperator.xlAnd,
          Type.Missing,
          true);
  </code></pre>
  
  <p>...or like so:</p>
  
  <pre><code>Range column1Row6 = _xlSheet.Range[_xlSheet.Cells[6, 1], _xlSheet.Cells[6, 1]];
  column1Row6.AutoFilter(1,
          Type.Missing,
          XlAutoFilterOperator.xlAnd,
          Type.Missing,
          true);
  </code></pre>
  
  <p>...so that it looks like this:</p>
  
  <p><a href="https://i.stack.imgur.com/wdZln.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wdZln.png" alt="enter image description here"></a></p>
  
  <p>...but I only want the filtering for the first column, from row 6 (the "from row 6" part is working fine), not columns 2, 3, 4, and 5 (and there could be more).</p>
  
  <p>How can I have the filter only on the first column (A, or 1) not over the entire row?</p>