Ctrl + Shift + Arrow stopped working (3 Solutions!!)

Channel	Publish Date	Thumbnail & View Count	Actions
	Publish Date not found	0 Views	View on YouTube Channel URL not found

Ctrl + Shift + Arrow stopped working

The Question: 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.

Solutions: Please watch the whole video to see all solutions, in order of how many people found them helpful

== This solution helped 2 people ==
Check if Transition Navigation Keys under /”Lotus compatibility/” is checked.
File -＞ Options -＞ Advanced, and scroll down to the bottom
That should be unchecked for the default behavior you had before

== This solution helped 12 people ==
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:

Then to activate it turn off scroll lock the button looks like the below link
to google image search: https://www.google.com/
search?q=scroll%20lock%20image&bih=681&tbm=isch

With thanks & praise to God, and with thanks to the many people who have made this project possible! | Content (except music & images) licensed under cc by-sa 3.0 | Music: https://www.bensound.com/royalty-free-music | Images: https://stocksnap.io/license & others | With thanks to user user 99572 is fine (https://superuser.com/users/99572), user SeanC (https://superuser.com/users/136090), user Rodrigo Briceno (https://superuser.com/users/149635), user Peter Albert (https://superuser.com/users/178313), user Nic (https://superuser.com/users/329135), user kenorb (https://superuser.com/users/87805), and the Stack Exchange Network (http://superuser.com/questions/465913). Trademarks are property of their respective owners. Disclaimer: All information is provided /”AS IS/” without warranty of any kind. You are responsible for your own actions. Please contact me if anything is amiss at Roel D.OT VandePaar A.T gmail.com.