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.
0 kommentar(er)
