Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
All articles Arrow keys scroll Excel How to use the Arrow keys Scroll in Excel – Excelchat

How to use the Arrow keys Scroll in Excel – Excelchat

The arrow keys in Excel allow us to scroll through our worksheet without changing the highlighted cell.

They are great for skimming through data.

Excel arrow keys Scroll Lock is displayed on the status bar.

Figure 1. of Arrow Keys Scroll in Excel

Whenever Scroll Lock is enabled, we can use the Excel arrow keys for scrolling through our worksheet without affecting the highlighted cell.

How to use Arrow Keys in Excel

Typically, when we select cell on an Excel sheet and then click on the arrow keys (keyboard), our selection cursor moves across each cell, either up, down, right, or left depending on which arrow key is pressed.

However, if we press those same arrow keys while Excel arrow keys Scroll Lock is turned on, we can only scroll up one row, or down one row. And also, scroll left one column, or right one column.

Figure 2. of Scroll Lock in Excel

Excel arrow keys Scroll Lock is a toggle lock key enabled on the keyboard; similar to the CAPS LOCK keyboard key. Once pressed, Excel Scroll Lock is switched ON.

To restore normal use of the Excel arrow keys for movement between cells, we must turn OFF Scroll Lock.

Press the SHIFT+F14 keys to switch Scroll Lock ON or OFF.

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc