Press F2 in a cell that has text, and a text cursor will appear at the end of it, enabling you to add more content or edit the existing text.
![excel shift cells down hotkey excel shift cells down hotkey](https://miro.medium.com/max/2730/0*DPPd6GgLLwmI8BJ9.png)
If you want to use the "Values" option from this dialog box, then continue and press Alt+v, and finish with Enter. Try it.Ĭtrl+Home should jump the active cell to cell A1Ĭtrl+1 (Ctrl and the number one) will open the "Format Cells" dialog box (very useful!)Īlt+E and then S – will open the "Paste Special" dialog box. It is relevant if you have already some data written in your worksheet, otherwise in an empty worksheet it will jump to the really last cell in the worksheet. For example: A100Ĭtrl+End will jump to the last cell of your data in the worksheet (the most bottom-right cell). Press Ctrl+G, and write the destination cell's address. Jumping to specific locations in the worksheet: Select the whole row by pressing Shift+SPACE, and column by pressing Ctrl+SPACE One extremely efficient way of selecting a region, is to have the active cell inside that region, and pressing Ctrl+Shift+8 To choose the next worksheet (Like going from Sheet1 to Sheet2): Ctrl+PgDownĬhoose the previous worksheet: Ctrl+PgUp Shortcuts for efficiently selecting regions:īy holding down Ctrl+Shift and pressing one of the arrows, you can accordingly select all the way to the left, right, top and bottom of the region.įor example: Selecting all the way to the bottom of the region: Ctrl+Shift+Arrow down You get into "Insert" mode by pressing Alt+i, and then the first letter of either Row, Column or Worksheet.
![excel shift cells down hotkey excel shift cells down hotkey](https://static.javatpoint.com/ms/excel/images/insert-column-excel-shortcut1.png)
(this specific shourtcut will select all the way to the bottom of a region) Shortcuts for inserting rows, columns and worksheets: You should press them down in the order they are written here, otherwise it might not work. Shift+Ctrl+Arrow Down means: pressing together the Shift key, with the Ctrl key, with the Arrow Down key. (This specific shourtcut will perform a "Copy" action). (This specific shourtcut will select a row)Ĭtrl+C means: pressing Ctrl together with the letter C. Shift+SPACE means: pressing shift together with the space bar. Here are three abbreviation examples just to make the information coming next clear: Would'nt it be easier to just to click Ctrl+N? (The Ctrl key together with N) Only now you can bring your hand back to the keyboard and continue your work. You can press the Home key to move the cursor back up quickly.The main improvement that the keystrokes offer is that you don't have to get your hands off the keyboard and grab the mouse and start visually searching for menus and buttons.įor Example, to add a new workbook (a new Excel file) without a shortcut, you must click the "Office Button", choose "New" and then double click the "Blank Workbook" icon. Note that the first method does come with a minor caveat - your view/cursor will move to the bottom of the spreadsheet (which does not happen with the Ctrl+Y method). you don't use the context menu button to modify anything). All subsequent work can be done purely with the keyboard, so long as you only use it to enter data (i.e. This means that you do need to use the mouse, but only the first time. To repeat the "auto-fill down" step, so long as you only enter data and press enter, you can repeat it by pressing Ctrl+Y. Once you fill in the cell you want to auto-fill downwards, double-click the bottom right corner as usual. Method 2 (my preferred way, one-time mouse interaction) Then, press Ctrl+D to "fill down" into the entire range from the top cell. After you enter the data in the cell, press Ctrl+Shift+End to select from the current cell to the end of the range that would be auto-filled. Method 1 (alternate, but it works with no mouse interaction)Īnother way to accomplish this is to use a combination of the fill-down shortcut and the select all in range.
![excel shift cells down hotkey excel shift cells down hotkey](https://cdn.educba.com/academy/wp-content/uploads/2019/01/Filter-Shortcuts-in-Excel.png)
Should you go the macro route, the AutoFill method on any Range object should be all that you need. Outside of these two methods, I do not believe you can accomplish what you seek without the use of macros or add-in modules. I highly suggest you try both methods and then determine which works best for you. Unfortunately, both methods do have their own caveats, since Excel does not provide an all-in-one keyboard shortcut for auto-fill.
![excel shift cells down hotkey excel shift cells down hotkey](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/06/extend-selection-by-one-cell-down.png)
I provide you with two methods to accomplish what you want.