Excel shortcuts

How to Use the Scroll Lock Feature on Microsoft Excel

The scroll lock feature on Microsoft Excel can be a great way to scroll through your spreadsheet without having to use the mouse. This can be especially useful if you have a lot of data in your spreadsheet. Here's how to use the scroll lock feature on Microsoft Excel:

  1. Open Microsoft Excel.
  2. Click on the 'View' tab.
  3. Click on 'Freeze Panes'.
  4. Click on 'Freeze Panes' again.
  5. Click on the cell where you want the frozen panes to start. For example, if you want to freeze the top row, click on the cell in the first row and first column.
  6. Click 'OK'.
  7. Now you can scroll through your spreadsheet without the top row moving. To scroll, just use the arrow keys on your keyboard.

The scroll lock feature can be a great way to make it easier to work with large spreadsheets. Give it a try the next time you're working with a large spreadsheet in Microsoft Excel.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.