how to fix first column in excel, MS Excel 2016 Unhide
How To Lock A Column In Excel When Scrolling. Web go to the view tab and click the freeze panes button. 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.
how to fix first column in excel, MS Excel 2016 Unhide
Lock top row in excel when scrolling. First, you need to make sure that the row you want to lock is visible at the top. You can scroll up to do so. Web go to the view tab and click the freeze panes button. Then select view >> freeze panes >> freeze top row. Tap view > freeze panes, and then tap the option you need. From the drop down menu select if you want the header row, the first row of data, or the header column, the first column of data to be frozen. Demonstrate how to freeze the selected column. Select the cell below the rows and to the right of the columns you want to keep visible when. Web freeze the first two columns.
Demonstrate how to freeze the selected column. Then select view >> freeze panes >> freeze top row. 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 go to the view tab and click the freeze panes button. Demonstrate how to freeze the selected column. First, open your excel spreadsheet and click on the column header to select the entire column that you want to lock. Lock top row in excel when scrolling. Select the cell below the rows and to the right of the columns you want to keep visible when. You can scroll up to do so. From the drop down menu select if you want the header row, the first row of data, or the header column, the first column of data to be frozen. Web freeze the first two columns.
