搜尋此網誌

2017年4月12日 星期三

[Excel] Freeze panes to lock rows and columns

https://support.office.com/en-us/article/Freeze-panes-to-lock-rows-and-columns-dab2ffc9-020d-4026-8121-67dd25f2508f
  1. To lock more than one row or column, or to lock both rows and columns at the same time, move your cursor to the first scrolling cell (i.e. your cursor is below the rows you want to freeze and to the right of any columns you want to freeze).
  2. Then choose the View tab, and then click Freeze Panes

沒有留言: