Excel Lock Headers. Freeze columns and rows select the cell below the rows and to the right of the columns you want to keep visible when you scroll. Web follow these three steps to get your worksheet's header to stay in place.
Unlock Excel Spreadsheet —
Tap view > freeze panes, and then tap the option you need. Select view on the ribbon. If you're using excel for mac, skip this step. Select view > freeze panes >. Web in a large worksheet with headings, you might want to make sure that the top row repeats when scrolling, so you can always see it. Freeze columns and rows select the cell below the rows and to the right of the columns you want to keep visible when you scroll. In the ribbon, select view > freeze panes. Web if you change a data set or list into a table, excel will automatically freeze the header row (column headings) so that when you scroll down, the header row will always be locked in place at the top of the table. Web follow these three steps to get your worksheet's header to stay in place. Web select view > freeze panes > freeze panes.
If you're using excel for mac, skip this step. Select view > freeze panes >. Freeze columns and rows select the cell below the rows and to the right of the columns you want to keep visible when you scroll. Web select view > freeze panes > freeze panes. Tap view > freeze panes, and then tap the option you need. Web in a large worksheet with headings, you might want to make sure that the top row repeats when scrolling, so you can always see it. Web follow these three steps to get your worksheet's header to stay in place. If you're using excel for mac, skip this step. In the ribbon, select view > freeze panes. Web if you want the row and column headers always visible when you scroll through your worksheet, you can lock the top row and/or first column. Web if you change a data set or list into a table, excel will automatically freeze the header row (column headings) so that when you scroll down, the header row will always be locked in place at the top of the table.
