how to fix first column in excel, MS Excel 2016 Unhide
Lock Headings In Excel. 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. Select view > freeze panes >.
how to fix first column in excel, MS Excel 2016 Unhide
Click the view tab in the ribbon and then click freeze panes. In the zoom category, click on the freeze panes drop down. If you want to freeze row 2 but do not want to freeze any columns, click in a3. Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. Freeze panes to keep track of where you are in a spreadsheet. It freezes the rows as well as the columns. Web select view > freeze panes > freeze panes. Web click the view tab. Web for example, if you want to freeze row 6 and column a, click in b7. Tap view > freeze panes, and then tap the option you need.
Select view > freeze panes >. Web how to freeze column and row headings in excel. 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. In the zoom category, click on the freeze panes drop down. Web click the view tab. Web for example, if you want to freeze row 6 and column a, click in b7. It freezes the rows as well as the columns. Web select view > freeze panes > freeze panes. If you want to freeze row 2 but do not want to freeze any columns, click in a3. Tap view > freeze panes, and then tap the option you need. Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.
