Excel: How to Keep Fixed Column Title Row While Filtering/Sorting Data

To add filters for row 1 that apply to rows 3 to 4 and keep row 2 ("Summary") static, not modified/impacted by filters, in your Excel data, you can follow these steps:

1. First, ensure that your data is structured as follows:

| Row | Column A | Column B | Column C | Column D |
|---|---|---|---|---|
| 1  | Filter 1 | Filter 2 | Static | Column D Data |
| 2  | Summary |  |  |  |
| 3  | Data 1 | Data 2 | Data 3 | Data 4 |
| 4  | Data 5 | Data 6 | Data 7 | Data 8 |
| ... | ...     | ...     | ...     | ...     |

2. To apply filters to rows 3 to 4 based on the values in rows 1, use the following formulas in rows 3 and 4:

=IF(AND(A3=Filter1, B3=Filter2), "Filtered", "Not Filtered")
=IF(A4=Static, "Static", IF(AND(A4=Filter1, B4=Filter2), "Filtered", "Not Filtered"))

Replace Filter1, Filter2, and Static with your actual filter values and the text you want to display for each condition.

3. After applying the formulas, you can use conditional formatting to highlight filtered rows. To do this, select rows 3 to 4, click on "Conditional Formatting" in the Home tab, choose "Highlight Cells Rules," and then "Equal to." Enter the filtered value and set the fill color as desired.

4. To keep row 2 static, you can either leave it empty or fill it with a value that does not match any filter condition.

Here's the resulting plain HTML output:

<table>
  <thead>
    <tr>
      <th>Row</th>
      <th>Column A</th>
      <th>Column B</th>
      <th>Column C</th>
      <th>Column D</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td>1</td>
      <td>Filter 1</td>
      <td>Filter 2</td>
      <td>Static</td>
      <td>Column D Data</td>
    </tr>
    <tr>
      <td>2</td>
      <td>Summary</td>
      <td></td>
      <td></td>
      <td></td>
    </tr>
    <tr>
      <td>3</td>
      <td>Data 1</td>
      <td>Data 2</td>
      <td>IF(AND(A3=Filter1, B3=Filter2), "Filtered", "Not Filtered")</td>
      <td>Data 4</td>
    </tr>
    <tr>
      <td>4</td>
      <td>Data 5</td>
      <td>Data 6</td>
      <td>IF(A4=Static, "Static", IF(AND(A4=Filter1, B4=Filter2), "Filtered", "Not Filtered"))</td>
      <td>Data 8</td>
    </tr>
    <!-- ... -->
  </tbody>
</table>

This HTML output includes the filters and the static row as requested. The formulas are enclosed in <td> tags, properly formatted according to the programming language (Excel formulas). The <thead> and <tbody> tags are used to separate the header and body of the table. The table is self-contained and does not use any page layout tags like <div>, <hr>, etc.