My system was upgraded to Windows 10 and Excel 2016 two weeks ago, and since then, the Excel key combination Ctrl+Shift+Down (arrow) doesn't work to select cells. For example, Ctrl+Shift+End selects everything from where you are to the farthest used cell. Both result in an array of results if you begin by selecting a range of cells, but only the formula entered using Ctrl+Shift+Enter is what Excel conventionally terms an “array formula.” Here’s the difference. If you want to identify differences within a row , use Ctrl + \ . Hi John, This shortcut is not working for me, in both a normal range and a table, selecting a header cell then ctrl + shift + L doesn’t toggle the filter, it simply moves the header cell selection across 1 column to the right (Excel 2013). Equivalent to the File ⇨ Print (E) TYPE 5: EXCEL CTRL SHORTCUTS WITH ‘ CTRL' KEY & ‘NAVIGATION' KEYS • Ctrl + → (Right Navigation Arrow) 1. Formula Entry mode is when you select a cell in Excel, type = and then start typing a function. Ctrl+Shift+Space: Select the entire worksheet; Editing Cells. My only suggestion is to see if the loss of this behavior is consistently tied to opening a certain workbook. When […] Move right to the edge of a database 2. This combination does nothing, and Ctrl+Shift+Window+Down makes the Excel window go away. There are also shortcuts that combine Ctrl and Shift. Shift+Insert: Copies the selection to the clipboard (same as Ctrl+C). I can close and reopen Excel to recover my normal behavior. When you press Ctrl+Shift+Enter, Excel automatically inserts the formula between { } (a pair of opening and closing braces). Tip: You can also click the first column heading, and then press CTRL+SHIFT+END. F2: Edit a cell; Shift+F2: Add or edit a cell comment; Ctrl+X: Cut contents of a cell, selected data, or selected cell range; Ctrl+C or Ctrl+Insert: Copy contents of a cell, selected data, or selected cell range With the range selected, just type Ctrl + Shift + \ (backslash) and Excel will instantly identify the cells with discrepancies. This is for differences within a column . • Ctrl + Shift + F12 / Ctrl + P / Ctrl + F2 Print Preview. If you press an arrow key in this mode, the selected cell in the formula will change, but the arrow keys won't control the cursor in the sheet. If there is a blank cell, move right to the first non-blank cell • Ctrl + ↓ … If you want to enter both the current date and time, type control +;, then enter a space, followed by Control + Shift + : With either shortcut, excel will enter the current date or time using a valid Excel date in serial number format, with dates as integers and times as decimal values. Step 4 – Now press Ctrl+Shift+Down to select all the cells up to the bottom (up to the row which you selected in Step 2) Note: If the problem is not yet resolved and excel still partially selects the data after pressing Ctrl+shift+down, then press the key combination again a few more times until the selection reaches down to the required row. To get arrow keys working again, press Enter and then Ctrl-Z … Excel also provides some keyboard shortcuts for editing cells. There’s an important difference between entering a formula by means of the keyboard combination Ctrl+Enter, and by means of Ctrl+Shift+Enter. 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. The curly brackets ({}), which should not be added manually, are added automatically. Just as Ctrl helps you “jump” on the worksheet, Shift enables you to select cells. However, Ctrl+Shift+Across (arrow) still works to select across a row! You can then apply date or time formatting as you like. The most popular of this group are the navigation shortcuts. Note: If you have a current version of Microsoft 365 , then you can simply enter the formula in the top-left-cell of the output range, then press ENTER to … To select all rows below the last row that contains data, click the first row heading, hold down CTRL, and then click the row headings of the rows that you want to select. Excel Shortcuts: Ctrl+Shift. Ctrl+Shift+Enter: Enters the contents of the formula bar as an array formula into the current cell or the selected range of cells.