开发者

How do we make the header(s) shown always at the top of the sheet

开发者 https://www.devze.com 2023-01-09 07:12 出处:网络
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

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
0

精彩评论

暂无评论...
验证码 换一张
取 消