A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
If Excel keeps moving far beyond the data, use one of these controls depending on what “to eternity” means:
- If the sheet keeps scrolling when using the arrow keys, turn off Scroll Lock.
- In Excel, check the status bar for Scroll Lock.
- Press the ScrLk key on the keyboard.
- If the keyboard does not have that key, open On-Screen Keyboard from Start, then select ScrLk to turn it off.
- If the worksheet keeps moving while using the mouse or wheel, use the scroll bar arrows or keyboard arrow keys instead. Those snap the sheet back to cell boundaries and give more controlled movement.
- If the issue is that the top row or first column should stay visible while scrolling, use View > Freeze Panes.
- To keep rows or columns visible, select the cell below the rows and to the right of the columns to keep visible.
- Then select View > Freeze Panes > Freeze Panes.
- To remove it later, use View > Freeze Panes > Unfreeze Panes.
- If the scroll bars themselves are distracting or behaving unexpectedly, they can be shown or hidden in:
- File > Options > Advanced
- Under Display options for this workbook, clear or select Show horizontal scroll bar and Show vertical scroll bar.
Excel also supports smooth scrolling by design, so partial row or column scrolling can occur with a mouse, touchpad, touch screen, or scroll bar drag.