
Also, programs tend to use the same shortcuts, so as you learn windows keyboard shortcuts or Chrome keyboard shortcuts, you can try them out in other programs. Some shortcut keys make sense, like Ctrl+C as the keyboard shortcut for copy, but don’t just guess at them – some shortcut keys are less intuitive, like the keyboard shortcut for paste, Ctrl+V (Because Ctrl+P is already used for printing)or Ctrl+X for the cut shortcut. Make a reference list of shortcuts you think will be useful, and practice using them. When you open a menu in your Opera browser (like the O in the top-left corner) you’ll see that keyboard shortcuts are listed next to their menu items to help you learn them. The modifier key (sometimes two keys) is held down while you press the other shortcut keys. Keyboard shortcuts use modifier keys (keys only used in tandem with other keys) like Ctrl, Alt, Shift or Command (⌘) in combination with other keys. Keyboard shortcuts, also called hotkeys, computer shortcuts, shortcut keys or just shortcuts, help you perform computer actions quicker. If you select even just a few of the following keyboard shortcuts and practice using them, you’ll save quite a lot of time and work much more efficiently in the long run. Below we’ve collected some groups of hotkeys for different contexts that are extremely useful for your daily browsing and computer use. Note that in Excel 2016, the shortcut to close the Excel help dialogue box is CTRL + Spacebar + C.Īlt + F4 can also be used outside of Excel – it is a universal shortcut for Windows that will close any application.Everyone knows a few useful keyboard shortcuts, but we also know that there are hundreds more we could be using. However, ALT + F4 will conveniently close this dialogue box – just as quickly as it was opened. While pressing the Escape key will typically close a dialogue box in Excel, in this instance it has no effect.

If you are a frequent user of the F2 key, you have likely accidentally pressed F1 – which of course brings up the Excel help dialogue box. We also like ALT + F4 for the following common issue in Excel. Note that in Excel 2013 and later, Alt + F4 will either close the current workbook (if there are many workbooks open), or close the current workbook and Excel itself (if it is the only workbook open). If you would like to close all workbooks that are open, as well as Excel itself, the shortcut that will achieve this is Alt + F4.

Both CTRL + W and CTRL + F4 will close the current workbook. However, there are many different ways to close workbooks. Most people know that CTRL + N will create a new workbook in Excel. This includes the creation of new workbooks right up to and including the closing of these workbooks – or even the closing of Excel itself.

At Marquee, we are strong advocates of using the keyboard for all things Excel.
