开发者

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
0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜