Excel Arrow Keys Move Page Not Cell

 Olivia Luz    

 
How To Fix Arrow Keys Not Working In Excel

Once you turn off scroll lock ms excel will.

To fix this issue you just need to turn off scroll lock. Excel up and down arrow keys move page instead of cell. If the above reason is why the arrow keys are not working in excel on your computer fixing it is just a matter of a key press. There s an easy fix for this.

Simply press the scroll lock button on your keyboard and the lock will be disabled. Look for the scrlk key on your keyboard and press it once to disable scroll lock. Once scroll lock is enabled microsoft excel moves the whole worksheet up and down instead of moving between cells when you press up and down keys. Formula entry mode is when you select a cell in excel type and then start typing a function.

Annoyingly the arrow keys on the keyboard don t move to the next cell in microsoft excel anymore. Following screenshot shows scroll lock alert displaying in ms excel status bar. When the arrow keys scroll through your entire spreadsheet rather than moving from cell to cell the culprit of this behavior is the scroll lock key. Microsoft excel also shows an alert in status bar when scroll lock is turned on.

RELATED ARTICLE :

To fix this and make the arrow keys move the active cell in microsoft excel simply turn scroll lock off. 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. But instead of moving to the next cell the whole worksheet moved.

Scroll lock makes the arrow keys move the page rather than the active cell in microsoft excel. To get arrow keys working again press enter and then ctrl z to undo the current. If you press an arrow key in this mode the selected cell in the formula will change but the arrow keys won t control the cursor in the sheet.

Image Gallery

How To Fix Arrow Keys Not Working In Excel

How To Fix Arrow Keys Not Working In Excel

Fix Arrow Keys Not Working In Excel Appuals Com

Fix Arrow Keys Not Working In Excel Appuals Com

How To Fix Excel S Spreadsheet Cell Keyboard Navigation

How To Fix Excel S Spreadsheet Cell Keyboard Navigation

Arrows Keys Not Working In Excel Excel Scroll Lock Microsoft Excel

Arrows Keys Not Working In Excel Excel Scroll Lock Microsoft Excel

Ctrl Shift Down Or Any Arrow Key Not Working Properly In Ms Excel How To Solve How To Excel

Ctrl Shift Down Or Any Arrow Key Not Working Properly In Ms Excel How To Solve How To Excel

Quickly Fix Arrow Keys Not Working In Excel On Windows 10

Quickly Fix Arrow Keys Not Working In Excel On Windows 10

Arrows Not Moving Cells In Excel Solved

Arrows Not Moving Cells In Excel Solved

Editing A Formula Using Keyboard

Editing A Formula Using Keyboard

How To Disable Scroll Lock In Excel Exceljet

How To Disable Scroll Lock In Excel Exceljet

How To Move Around An Excel Worksheet Dummies

How To Move Around An Excel Worksheet Dummies

Curse You Excel Cursor My Online Training Hub

Curse You Excel Cursor My Online Training Hub

Https Encrypted Tbn0 Gstatic Com Images Q Tbn And9gcqeu0fevolx5cbwvr Ngihex1c2abu0w Mbig Usqp Cau

Https Encrypted Tbn0 Gstatic Com Images Q Tbn And9gcqeu0fevolx5cbwvr Ngihex1c2abu0w Mbig Usqp Cau

Moving Selected Cell Data In Excel Right Or Left Without Using Cut Paste Or Copy And Paste Move Data With Arrow Keys Would Be Great Super User

Moving Selected Cell Data In Excel Right Or Left Without Using Cut Paste Or Copy And Paste Move Data With Arrow Keys Would Be Great Super User

Source : pinterest.com

Another Post: