title: dynamically freezing panes in excel
body: <p>I have an excel sheet with data in the following format:</p>
  
  <pre><code>Title
  Summary A
  A info 1
  A info 2
  A info 3
  Summary B
  B info 1
  B info 2
  Summary C
  </code></pre>
  
  <p>so right now I have only "title" as a frozen pane in excel. It works fine and all but there is a lot of data so when you are in the middle of the sheet its hard to know whether you are working in <code>summary A</code> or <code>summary B</code>. </p>
  
  <p>Does anyone know how to freeze panes dynamically? ie, initially <code>title</code> and <code>Summary A</code> will be frozen. Then as the user scrolls down until the next section then <code>Title</code> and <code>Summary B</code> will be frozen and so on.</p>