Filter data option in excel is useful to filter data based on a certain criteria. How do we make the header(s) shown at the top always as we scroll down the excel sheet.
+6
A:
Freeze the row and column
Instructions at : http://office.microsoft.com/en-us/excel-help/freeze-or-lock-rows-and-columns-HP001217048.aspx
Ankit Jain
2010-07-30 08:14:13
This Excel 2010 feature might make freeze panes unnecessary in this situation - http://blogs.msdn.com/b/excel/archive/2010/01/25/table-improvements-in-excel-2010.aspx
barrowc
2010-08-01 20:12:19