The solution is simple. I can move the cursor to the row below and select it that way. Any suggestions would be greatly appreciated. I can't move the "little square" in excel using the arrow keys. http://pgelections.com/scroll-lock/arrow-keys-not-working-in-excel-not-scroll-lock.html
If the address doesn't change change, Scroll Lock is probably turned on. It has nothing to do with the Scroll Lock being on or off. Answer / Solution: It's very possible that you need to click the 'SCROLL LOCK' button on your keyboard. My son uses this keyboard for touch typing practise, so he must've hit it by accident as it was working the other day. https://social.technet.microsoft.com/Forums/office/en-US/257b033d-31c3-47dc-85f2-0c60c8b3f303/excel-arrow-keys-stop-working-not-scroll-lock?forum=excel
To determine if this is the case, right-click the Excel status bar. You've saved the day ... It is NOT scroll lock... There are no macros. ) I want to do this because I want to look at the interactions between 8 factors, but cannot set up an 8 x 8 matrix because
You'd think that you could go System Preferences > Keyboard, then enable an extended virtual keyboard, then use that to press F14. Can Newton's laws of motion be proved? If the user inserts a new line in the work area, or they hit the save button,which they should be able to do, they then lose control of the down arrow. http://www.computerhope.com/issues/ch001217.htm when i click another tab then back ...all works again..
asked 11 months ago viewed 1039 times Related 2Can't type letter Z on laptop keyboard and arrow keys don't work1Using the arrow keys quicker?2Excel 2013 error when launching Excel files0Win 8.1 Scroll Lock Lenovo I am unable to use the arrow keys to move between cells. If you have an extended keyboard with an F14 key, try that first. Have you got Sticky Keys enabled? –Burgi Dec 18 '15 at 15:55 It's Windows 7 Pro –Philippe Dec 18 '15 at 16:00 1 Thanks Burgi, it was the
WTF?! Before you panic and call support to tell them Excel is broken, check to see if Scroll Lock has been accidentally enabled. What is Scroll Lock? their explanation If you know a way to enable an extended virtual keyboard (on a Mac that doesn't have one attached), please let me know. Scroll Lock Excel Shortcut On my keyboard, it's on the upper-right hand corner, near the INS, DEL, HOME and END buttons, and it's labelled 'SCROLL LOCK'. Scroll Lock Excel Mac I have all the latest patches and have rebooted ..
Thanks rizvisa1 - didn't even realise I had one. http://pgelections.com/scroll-lock/arrow-keys-not-working-in-excel-mac.html Thank you so much - so simples! NOTHING moves.. I have verified EXT is not in the status bar by clicking F8 repeatedly. Scroll Lock Key
No other unlocked cells are merged. The following sections give quick, simple instructions for turning off the scroll lock feature. What I've found however is that it sometimes ignores cells with content, and my cursor goes to the bottom of the sheet, leading me to believe that a column is empty this content Turning off scroll lock without the keyboard key Windows XP, Vista, and 7 users Click the Start Button in the lower left-hand corner of your desktop.
Also, I don't use User Defined Functions. Scroll Lock On Laptop Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Click Here to Join the Discussion Tweet Lori Kaufman is a writer who likes to write geeky how-to articles to help make people's lives easier through the use of technology.
I would like to be able to move the cursor from column to column without having to go back to the PC and keyboard, keying it in. That works fine. Share a link to this question via email, Google+, Twitter, or Facebook. have a peek at these guys Many thanks Andrew Ask Your Own Question Using Shift+f8 The Right Way? - Excel Excel Forum Hi, I am using Excel 2003.
Report rizvisa1 4482Posts Thursday January 28, 2010Registration date ContributorStatus February 12, 2016 Last seen - Jun 11, 2010 06:15PM I have yet to see a keyboard without one. Was this page useful? For example, I would like my cursor movement to go something like this: CELL MOVEMENT B5 DOWN B6 DOWN B7 DOWN B8 FIRST CELL IN NEXT SECTION G5 RIGHT H5 DOWN/LEFT Being a member gives you detailed monitoring of your requests.
But I want to be able to just tab all the way through all unlocked cells on the sheet. Mac Excel 2011 doesn't show scroll lock status anywhere. I am scanning away from the PC and keyboard and what I am scanning needs to go into different columns, completing one column and then moving to the next. Privacy statement.
KR Edited by robbery kr Wednesday, March 25, 2015 2:01 AM Wednesday, March 25, 2015 2:01 AM Reply | Quote 0 Sign in to vote Clean booted several times.. How can we improve it? even the mouse wheel will not move anything on spreadsheet.. What is causing this behavior?
Report rizvisa1 4482Posts Thursday January 28, 2010Registration date ContributorStatus February 12, 2016 Last seen - Jun 11, 2010 06:29PM Glad it worked out for you, Cheers!!! If you see a small bar with a few keys, click General. The On-Screen Keyboard in Windows, Scroll Lock key in white Once the keyboard is displayed, make sure Excel is the active application and click the ScrLk key. Here is how you will do for Logitech http://www.ehow.com/how_4617597_scroll-lock-off-logitech-keyboard.html Report Deb- Jun 11, 2010 06:28PM Thank you for the link!