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. Here are some of the keyboard shortcuts for working with pivot tables in Excel 2007 and Excel 2003.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. Sometimes it’s quicker to use a keyboard shortcut, instead of the mouse, to accomplish a task in Excel.
0 kommentar(er)
