Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When I work with a big amount of data, I introduce formulas in Excel by using the shortcut: Ctrl+Shift+arrow. That shortcut allows me to select a whole set of data to the left, right, up or down. Yesterday, I made a change in my regional settings (changed the use of U.S. system to the metric system). After that change, I was no longer able to select data for formulas using that key combination.

Do anybody has an idea how to recover this functionality? I searched on Google, and many of the answers point to uncheck some Excel options regarding Lotus compatibility, but these options are already unchecked on my Excel.

Any helps is very well appreciated.

share|improve this question

Check if you have not accidently activated the Scroll Lock button on your keyboard.

In case this has happened, Excel actually shows this in the status bar:

enter image description here

Then to activate it turn off scroll lock the button looks like the below link to google image search: Googled search of scroll lock

share|improve this answer
not always , in my case excel dose not show it but it worked thanks :) – shareef Oct 27 '15 at 7:49

Check to see if Transition Navigation Keys is checked.

File -> Options -> Advanced, and scroll down to the bottom

That should be unchecked for the default behavior you had before

share|improve this answer

I've had this problem as well, easiest fix for me, save file, exit file, re-enter file, and it's fixed.

share|improve this answer

You must log in to answer this question.

protected by Community Nov 27 '14 at 5:22

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged .