Most of the user know at least a handful of shortcuts for Microsoft Excel. However, an entire row of function keys shortcut is often neglected and even unknown to users. We are talking about the function keys that they just do not get enough attention from users of Microsoft Excel.
So let’s talk about Microsoft Excel Function Keys, from left to right.
- F1 by itself opens the Help task pane.
- Ctrl+F1 shows or hides the Ribbon newer versions of Excel.
- Alt+F1 will create a quick chart using data that is selected.
- Alt+Shift+F1 inserts a brand new worksheet/macro sheet.
- F2 moves the cursor to the end of the selected cell (edit cell mode).
- Ctrl+F2 shows Print Preview Window.
- Alt+F2 brings up the Save As dialog.
- Shift+F2 adds a comment.
- F3 opens the Paste Name box.
- Shift+F3 is a quick way to insert a function.
- F4 repeats your last action.
- Ctrl+F4 closes your window.