Quick Answer: How Do I Get My Arrow Keys To Work In Excel?

How do I fix scrolling in Excel?

1.

Select the Unfreeze Panes optionsIn most cases, users can’t scroll down Excel spreadsheets because there are frozen panes within them.

To unfreeze panes in Excel, select the View tab.Click the Freeze Panes button.Then select the Unfreeze panes option.

Thereafter, try scrolling down the spreadsheet..

What does the Ctrl key do?

In computing, a Control key Ctrl is a modifier key which, when pressed in conjunction with another key, performs a special operation (for example, Ctrl + C ); similar to the Shift key, the Control key rarely performs any function when pressed by itself.

What is the shortcut key for scroll lock in HP laptop?

The official Microsoft shortcut for Scroll Lock is Shift + F14. When the Scroll Lock mode was on, the arrow keys would scroll the contents of a text window instead of moving the cursor.

How do you scroll in Excel?

To scroll to the start and end of each range while selecting the ranges before stopping at the end of the worksheet, press CTRL+SHIFT+an arrow key. Press SCROLL LOCK, and then use the UP ARROW key or DOWN ARROW key to scroll one row up or down.

Why don’t my arrow keys work in Excel?

One of the common reasons why the arrow keys don’t work in Excel is because you’ve enabled the scroll lock feature on your computer. … Simply press the scroll lock button on your keyboard and the lock will be disabled.

How do I unlock Scroll Lock?

Turn off Scroll LockIf your keyboard does not have a Scroll Lock key, on your computer, click Start > Settings > Ease of Access > Keyboard.Click the On Screen Keyboard button to turn it on.When the on-screen keyboard appears on your screen, click the ScrLk button.

Why is Excel scrolling with arrow keys?

When the scroll lock feature is turned on, pressing an arrow key causes Microsoft Excel to move the entire spreadsheet, instead of moving to the next cell. Although helpful for a user viewing a large worksheet, it’s also quite annoying for those who have mistakenly enabled this feature.

Why do my arrow keys not work?

This can be the result of accidentally hitting the Scroll Lock key (often “ScrlLk”) on your keyboard, or the NumLock key. Try fiddling around with those before you shell out for a new keyboard.

Where is my Scroll Lock key?

Sometimes abbreviated as ScLk, ScrLk, or Slk, the Scroll Lock key is found on a computer keyboard, often located close to the pause key.

What is the shortcut key for Scroll Lock?

Shift + F14The official Microsoft shortcut for Scroll Lock is Shift + F14. If you have an extended keyboard with an F14 key, try that first.

Where is the f14 key?

Uses on computer keyboards It is sometimes used to modify the function keys. Modern Microsoft Windows keyboards typically have only 12 function keys; Shift+F1 must be used to type F13, Shift+F2 for F14, etc. It can modify various control and alt keys.

What does the f7 key do?

Commonly used to spell check and grammar check a document in Microsoft programs such as Microsoft Outlook, Word etc. Shift+F7 runs a Thesaurus check on word highlighted.

How do you type without shift key?

Hold down the ALT key, and then on your 10-key (the numbers grouped off to the right of the keyboard) hit the keys 6 and 4, then let go of the ALT key.

How do you unlock the keyboard?

How to unlock a locked laptop keyboardTry this: If your device seems unresponsive, your first step should be pressing down on Ctrl + Alt + Del at once to see if you can end a malfunctioning program or process. … Try this: Examine each key for cracks then determine that it moves when you press it.More items…•

How do I turn off keyboard lock?

Step 1: Turn Off Filter Keys Just then, you’ll find that the keyboard is locked and you can’t type anything. To unlock the keyboard, you have to hold down the right SHIFT key for 8 seconds again to turn off Filter Keys, or disable Filter Keys from the Control Panel.

What is scroll lock in Excel?

Scroll Lock is the feature that controls the behavior of the arrow keys in Excel. Usually, when the Scroll Lock is disabled, arrow keys move you between individual cells in any direction: up, down, left or right.