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, or you can Split panes …

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. Tap View > Freeze Panes, and then tap the option you need.

Lock specific rows or columns in place by freezing panes, so you can scroll through an Excel spreadsheet and still see the top row or left column. You can freeze just the top row and first column …

Pressing an arrow key while SCROLL LOCK is on will scroll one row up or down or one column left or right. To use the arrow keys to move between cells, you must turn SCROLL LOCK off.

Pressing an arrow key while SCROLL LOCK is on will scroll one row up or down or one column left or right. To use the arrow keys to move between cells, you must turn SCROLL LOCK off.

Splitting a worksheet lets you see two regions at the same time in different panes by scrolling in each pane. It freezes panes while you scroll in one of the panes.

When you create an Excel table, a table Header Row is automatically added as the first row of the table, but you have to option to turn it off or on.

Add a scroll bar or spin button to an Excel worksheet. The controls let you quickly enter or change a range of values.

When you draw, resize, or move a shape or other object in Excel, you can set it so that it will align or "snap” to the nearest intersection in the grid (even if the grid is not visible) or snap to other shapes or …

If showing and toggling scroll bars did not work to show the scroll bars, try resizing the app window. Right-click the title bar of the app window, and then select Maximize.