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)
