title: Freeze Column Headers in excel after export from ssrs
body: <p>I have created a report and now I need to freeze tablix header. I tried all the ways related to freeze panes in SSRS, but after export to excel, the freeze pane is not working. Do you know any way to achieve this in SSRS 2016?</p>
  
  <p>Below are the steps that I've tried: </p>
  
  <blockquote>
    <ol>
    <li>Select the tabix and click on Tablix properties.</li>
    <li>In the General tab under Column Headers section you can see "Keep header visible while scrolling" checkbox, check it.</li>
    <li>Now the header row will be remain fixed in the report.</li>
    </ol>
  </blockquote>
  
  <p>OR</p>
  
  <blockquote>
    <ol>
    <li>In the grouping pane, make sure to turn on advanced mode (click on the small black down arrow on the far right of the grouping pane)  </li>
    <li>Select the corresponding (Static) item in the row group hierarchy </li>
    <li>In the properties grid, set RepeatOnNewPage to true </li>
    <li>KeepwithGroup to After</li>
    </ol>
  </blockquote>
  
  <p>OR</p>
  
  <blockquote>
    <ol>
    <li>Freeze the header of all columns[ Freezing table header ] : To do select static member of table header row from  row groups [ Advanced
    Mode ] and set  FixedData to true</li>
    <li>Freeze the initial 2 columns : To do select static member of columns in column group and set fixedData to true.</li>
    </ol>
  </blockquote>