How do we make the header(s) shown always at the top of the sheet
Filter data option in excel is u开发者_Python百科seful 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.
Freeze the row and column
Instructions at : http://office.microsoft.com/en-us/excel-help/freeze-or-lock-rows-and-columns-HP001217048.aspx
View tab
Freeze Panes
- Freeze Panes /* everything to left and above current cell */
- Freeze Top Row
- Freeze First Column
精彩评论