Copy Formula (exact) from cell above: Ctrl + '.Copy Value from cell above: Ctrl + Shift + '.Use a shortcut key to fill right or down:.Select the range, starting with the cell that contains the data.Type the value or formula in the active cell.Select all the cells in which you want to enter the same value.Watch this short video to see the keyboard shortcuts for enteringĭates and times in a worksheet. Enter the current Time: Ctrl + Shift +.Use a shortcut key to quickly enter the date or time in your spreadsheet: Go to the Excel Shortcuts page for an interactive list, and to get the file.Here are some time-saving Microsoft Excel shortcuts to use when you're entering data. To open the 'Find and replace' dialog box: Ctrl+HĪdd a new Excel file (a new workbook): Ctrl+NĬtrl+C to Copy a selection, Ctrl+X to cut, Ctrl+V to Paste.More Data Entry Tutorials Data Entry Shortcuts And of course: all the general MS Office Shortcuts: Select your data (it should be organized neatly with rows and column headers), and press the F11 key. To have today's date change dynamically to reflect always the current date (whenever the worksheet is opened), then write the function =today() To insert today's date, press Ctrl+ (a semicolon). Position the active cell underneath a column of numbers, and press Alt+= (Alt key together with the equal sign) To remove the freeze panes, use the same shortcut. Put the active cell in the desired location, and press Alt+w and then F. Press Alt+Enter when writing text in a cell, to add a line break inside the cell. (This comes instead of double clicking with the mouse inside the text, or clicking in the formulas bar to edit it). 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. 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. (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. 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.

Command e in excel