ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   The arrow keys will not move between cells in Excel? Any ideas? (https://www.excelbanter.com/excel-discussion-misc-queries/215453-arrow-keys-will-not-move-between-cells-excel-any-ideas.html)

Lulu1974

The arrow keys will not move between cells in Excel? Any ideas?
 
The arrow keys just seem to have stopped working in all worksheets. I cannot
use them to move between cells. Any ideas?

ExcelBanter AI

Answer: The arrow keys will not move between cells in Excel? Any ideas?
 
I'm sorry to hear that you're having trouble with the arrow keys in Excel. Here are a few things you can try to fix the issue:
  1. Check if the Scroll Lock key is on: Sometimes, the Scroll Lock key can interfere with the arrow keys in Excel. Look for a key labeled "Scroll Lock" on your keyboard and press it to turn it off. You should see a light on your keyboard indicating whether Scroll Lock is on or off.
  2. Check if the arrow keys are working in other applications: If the arrow keys are not working in any application, it could be a problem with your keyboard. Try using a different keyboard to see if the issue persists.
  3. Check if the worksheet is protected: If the worksheet is protected, you may not be able to use the arrow keys to move between cells. To check if the worksheet is protected, go to the Review tab and look for the "Protect Sheet" button. If it's highlighted, click on it to unprotect the sheet.
  4. Check if the cells are locked: If the cells you're trying to move between are locked, you may not be able to use the arrow keys to move between them. To check if the cells are locked, right-click on the cell and select "Format Cells". Go to the "Protection" tab and make sure the "Locked" checkbox is unchecked.
  5. Check if the Excel options are set correctly: Go to the File tab and select "Options". In the "Advanced" tab, make sure the "Enable fill handle and cell drag-and-drop" checkbox is checked.

I hope one of these solutions helps you fix the issue with the arrow keys in Excel. Let me know if you have any other questions!

Mike H

The arrow keys will not move between cells in Excel? Any ideas?
 
Hi,

Tap Scroll lock

Mike

"Lulu1974" wrote:

The arrow keys just seem to have stopped working in all worksheets. I cannot
use them to move between cells. Any ideas?


Lulu1974

The arrow keys will not move between cells in Excel? Any ideas?
 
Just seen another post similar which suggested trying Scroll Lock and this
has worked! Thanks anyway!

"Lulu1974" wrote:

The arrow keys just seem to have stopped working in all worksheets. I cannot
use them to move between cells. Any ideas?


Lars-Åke Aspelin[_2_]

The arrow keys will not move between cells in Excel? Any ideas?
 
On Tue, 6 Jan 2009 01:23:00 -0800, Mike H
wrote:

Hi,

Tap Scroll lock

Mike

"Lulu1974" wrote:

The arrow keys just seem to have stopped working in all worksheets. I cannot
use them to move between cells. Any ideas?



I do happens that Scroll lock gets active even if you don't have a
keyboard with that key, and if you have one of those keyboards without
the Scroll lock key, look for the program On-Screen Keyboard for
"tapping" Scroll lock (=slk).

You could also use Excel macro statement
SendKeys "{SCROLLLOCK}"
to toggle the Scroll Lock.

Hope this helps / Lars-Åke


All times are GMT +1. The time now is 08:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com