I can close and reopen Excel to recover my normal behavior. I have wondered if some versions/international settings out there don't don't have or allow that shift-ctrl-arrowkey behavior, and that gets carried over with the workbook. My only suggestion is to see if the loss of this behavior is consistently tied to opening a certain workbook.
Dec 01, 2015 · Just as Ctrl helps you “jump” on the worksheet, Shift enables you to select cells. Excel Shortcuts: Ctrl+Shift. There are also shortcuts that combine Ctrl and Shift. The most popular of this group are the navigation shortcuts. For example, Ctrl+Shift+End selects everything from where you are to the farthest used cell.
Excel Shortcuts: 215 Of The Best Excel Shortcuts, including Ctrl+C, Ctrl+V, Ctrl+S, Ctrl+W, Ctrl+F, Ctrl+P, Alt-E-S-V, Ctrl+1, F2, F4, Copy, Paste, Find Faster At Excel Home CTRL + Shift + Page Up: Select the current and previous sheet in a workbook. CTRL + Shift + O: Select all cells with comments: Shift + Arrow Keys: Extend the selection by one cell. CTRL + Shift ... Ctrl+Shift+O Conditional select cells Conditional select cells Custom Popup Ctrl+Shift+P Convert formulas to their values Convert formulas to their values Custom Popup Ctrl+Shift+Q Quick numbering of cells Quick numbering of cells Custom Popup Ctrl+Shift+R Reset Excel's last cell Reset Excel's last cell Custom Popup Ctrl+Shift+S I can close and reopen Excel to recover my normal behavior. I have wondered if some versions/international settings out there don't don't have or allow that shift-ctrl-arrowkey behavior, and that gets carried over with the workbook. My only suggestion is to see if the loss of this behavior is consistently tied to opening a certain workbook.
239 Excel Shortcuts Below is a huge list of Excel keyboard shortcuts you can use to work faster. Scroll through the list or use the Index to quickly go to the section you want. Pressing Ctrl+Shift+Spacebar a second time selects the current region and its summary rows. Pressing Ctrl+Shift+Spacebar a third time selects the entire worksheet. When an object is selected, Ctrl+Shift+Spacebar selects all objects on a worksheet. Alt+Spacebar displays the Control menu for the Excel window. Excel Shortcuts - List of the most important & common MS Excel shortcuts for PC & Mac users, finance, accounting professions. Keyboard shortcuts speed up your modeling skills and save time. Learn editing, formatting, navigation, ribbon, paste special, data manipulation, formula and cell editing, and other shortucts CTRL+X Cuts the picked cells. CTRL+Y: Repeats the last order or movement, if conceivable. CTRL+Z: Uses the Undo order to inverse the end charge or to erase the last access which you wrote. CTRL+SHIFT+Z makes utilization of the Undo or Redo summon to inverse or repair the end mechanized rectification when AutoCorrect Smart Tags are shown Array formulas are often referred to as CSE (Ctrl+Shift+Enter) formulas because instead of just pressing Enter, you press Ctrl+Shift+Enter to complete the formula. If you have an experience using formulas in Excel, you know that you can perform some fairly sophisticated operations.