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.