Excel Pin Rows. In my excel, i want to pin several rows. So, we’ll select row 9.
How to Fix Rows in Excel
In my excel, i want to pin several rows. You see the first three rows: When i scroll up, the first three rows will be hidden: This makes it easy to tell which record or field you’re looking at! So, we’ll select row 9. Select the row below, the rows we want to freeze. Click the view tab on the ribbon. Unfreeze panes to unfreeze panes, tap. Web to freeze multiple columns (starting with column a), select the column to the right of the last column you want to freeze, and then tap view > freeze panes > freeze panes. Select view > freeze panes >.
Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. When i scroll up, the first three rows will be hidden: Unfreeze panes to unfreeze panes, tap. Web viewed 12k times. You see the first three rows: Select view > freeze panes >. Web freeze rows or columns. Web the freeze panes feature will allow you to pin the top row and first column so when you scroll around the sheet they always remain in view. Select the row below, the rows we want to freeze. In my excel, i want to pin several rows. Click the view tab on the ribbon.
