Excel Pin Row To Top When Scrolling. First, you need to make sure that the row you want to lock is visible at the top. In my excel, i want to pin several rows.
lasopaact Blog
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 modified 4 years, 6 months ago. Tap view > freeze panes, and then tap the option you need. When i scroll up, the first three rows will be. Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. Lock top row in excel when scrolling. Then select view >> freeze panes >> freeze top row. Select view > freeze panes >. You see the first three rows: You can scroll up to do so.
You can scroll up to do so. You see the first three rows: Web go to the view tab and click the freeze panes button. 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 scroll. Web modified 4 years, 6 months ago. First, you need to make sure that the row you want to lock is visible at the top. 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. 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. In my excel, i want to pin several rows. Select view > freeze panes >.
