#Excel 2016 keyboard shortcuts windows plus

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.

#Excel 2016 keyboard shortcuts windows plus

Now just remember we don’t type the plus sign in keyboard shortcuts in the same way we don’t pronounce punctuation (comma, exclamation mark) when reading out-loud.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. If that stumped you, great job of paying close attention. The plus sign is just a convention to indicate that the two things go together. She wanted to know if she was supposed to type the plus key as well. I received a question from a student about that. You’ll notice that I’m typing the plus sign (+) between the names of the keys. No more scrolling! Are you being too literal… And, not surprisingly, Ctrl + End ( Go To End shortcut) will take you to the end of your document in Microsoft Word. You’ll be taken to that page as soon as you press Enter without ever using the mouse.Ĭtrl + Home ( Go To Beginning shortcut) will always take you to the very beginning of page 1, no matter where you start from. With your cursor already placed in the Enter page number: field all you have to do is type the page number you want to Go To, then press the Enter key. If you type Ctrl + G in Microsoft Word you will open the Go To dialog box. No more scrolling! Microsoft Word Go To keyboard shortcutĬtrl + G is the Go To keyboard shortcut. And, not surprisingly, Ctrl + End ( Go To End shortcut) will take you to the end of your data in Microsoft Excel. You’ll be taken to that cell as soon as you press Enter without ever using the mouse.Ĭtrl + Home ( Go To Beginning shortcut) will always take you to cell A1 in your worksheet, no matter where you start from. With your cursor already placed in the Reference field all you have to do is type the address of the cell you want to Go To, then press the Enter key. If you type Ctrl + G in Microsoft Excel you will open the Go To dialog box. Microsoft Excel Go To keyboard shortcutĬtrl + G is the Go To keyboard shortcut. The techniques are the exact same between the two programs, the only real difference being the difference in appearance between the Go To dialog box in the two programs. Go ahead and find those on your keyboard before continuing. However, all types of keyboards should contain a Control key, Enter key, the Home key, and the End key. Every keyboard layout is slightly different, especially if you are comparing a desktop keyboard to a laptop keyboard. I’ve got two documents open on screen, and we’ll try these techniques out in each program. We’re going to talk about three different shortcuts today, the Go To, Go To Beginning and Go To End commands. You can see several of these shortcuts in the table. The key to using shortcuts is to be willing to experiment! If you want to do something with the keyboard, try holding down the Ctrl key and typing the first letter of whatever it is you want to do. These tools are called Command Shortcuts by Microsoft, but most everyone else knows them as Keyboard Shortcuts.

There are several great tools that will help you jump around in Excel and Word without having to use the mouse.