Excel Lock Heading Row. 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 the row headings (which appear on the left) can be one or more columns on the left of the data.
How to lock Excel 2007 Header Row YouTube
Scroll down until the top row or rows that. 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 what to know. View > freeze panes (windows only) > freeze top row. Freeze row and / or column headings. Web freeze panes to lock rows and columns. In the ribbon, 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. Tap view > freeze panes, and then tap the option you need. To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the view tab, where you can freeze panes to lock specific rows and columns in place,.
View > freeze panes (windows only) > freeze top row. To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the view tab, where you can freeze panes to lock specific rows and columns in place,. Scroll down until the top row or rows that. Web the row headings (which appear on the left) can be one or more columns on the left of the data. Web what to know. Freeze row and / or column headings. View > freeze panes (windows only) > freeze top row. Web freeze panes to lock rows and columns. View > freeze panes (windows only) > freeze first column. 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. Tap view > freeze panes, and then tap the option you need.
