Select any cell of the chosen table so that Excel understands with what data it will work. Pin the first column in the menu you will see.. Now, when the document is scrolled to the right horizontally, the needed column will be fixed. To freeze several columns, select the cell at the page bottom (to the right from the fixed column).
This of course begs the inquiry “How do I keep column headers when scrolling in Excel?”
Keep column header viewing when scrolling with Freeze Panes To keep the column headers viewing means to freeze the top row of the worksheet. Enable the worksheet you need to keep column header viewing, and click View > Freeze Panes > Freeze Top Row.
In most cases, users can’t scroll down Excel spreadsheets because there are frozen panes within them. To unfreeze panes in Excel, select the View tab. Click the Freeze Panes button. Then select the Unfreeze panes option. Thereafter, try scrolling down the spreadsheet.
Then, how to repeat rows when scrolling in Excel?
In the worksheet which you need to repeat rows when scrolling, click View > Freeze Panes. If you just want to repeat the first title row in this worksheet, please select the Freeze Top Row option from the Freeze Panes drop-down list.
How do I freeze a row when scrolling in Excel?
[Solution] Excel Freeze Rows 1 Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.
Locking a row in Excel while scrolling . 1 Create the needed table and fill it with the data. 2 Make any of the cells active. Go to the “VIEW” tab using the tool “Freeze Panes”. 3 In the menu select the “Freeze Top Row” functions.
How to prevent the top rows from scrolling in active worksheet?
This method is talking about preventing the top rows from scrolling in active worksheet with the Freeze Panes feature in Excel. Please do as follows: Click View > Freeze Panes > Freeze Top Row to freeze the top row in active worksheet.
How to make the cap visible when scrolling in Excel?
To make the cap visible when scrolling, fix the top row of the Excel table, following these actions: 1 Create the needed table and fill it with the data. 2 Make any of the cells active. Go to the “VIEW” tab using the tool “Freeze Panes”. 3 In the menu select the “Freeze Top Row” functions.