To make the cap visible when scrolling, fix the top row of the Excel table, following these actions:
Create the needed table and fill it with the data. Make any of the cells active. Go to the “VIEW” tab using the tool “Freeze Panes”. In the menu select the “Freeze Top Row” functions.
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.
This of course begs the inquiry “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.
Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.
How do I Fix an Excel file that doesn’t scroll?
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.
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 header row follow when scrolling down the worksheet?
This section will introduce the Freeze Panes function of Excel to make header row follow when scrolling down the worksheet. Shift to the worksheet you need to make header row follow, select cell A2 (or the first cell under your header row), and then click View > Freeze Panes > Freeze Panes., and see screenshot:.