Works only if your workbook is in a restored window. Opens the 'Spelling' option in excel using which you can check the spellings in your workbook Switch to the previous excel workbook if you have multiple workbooks open. If not switches between help task pane and application window.

Switch between the panes of an excel workbook if you have a split window. Restores the window size from maximum of the current open excel workbook. Select the empty cell available next in the right direction to the current selection. Select the empty cell available next in the left direction to the current selection. Same as Alt + F4 Function.Ĭloses the current open excel workbook window. Also repeats last action performed in workbook. Toggles between cell references – Absolute, Relative and Mixed Reference. Opens dialog box to select functions to insert in the selected cell Insert or Edit a comment in selected cellĬreate names from the row or column labels for the selected cell(s) So, below is a tabular format for you to know about the F1 to F12 function keys in excel in an easy to digest manner. This is a long post of around 3000 + words. We will also be discussing the output given by using function keys with Alt, Shift, and Ctrl Keys. Now let’s jump to our topic, 'Excel Function Keys' to get an insight about all the 12 Functions and how to use them. The concept of 12 Function Keys was introduced 31 years ago, in the year 1984 by using Model M type of Computer Keyboards. It might amaze you to know that the original 'Personal Computer Keyboard' from IBM in 1981 had only 10 Function Keys, F1 to F10.

Hence the use of Function Keys might vary from one application to another except for some keys like F1 which always provides you with the 'Help' options of the application. These ASCII Codes are interpreted by the application program like Excel, Word, Paint, etc. Function keys provide the same output in all versions of Excel making it easier to recall.īefore we head onto our topic, let us first know about the history of function keys and how do they work.įunction Keys generate fixed, single byte code that is outside the range of normally used ASCII Codes. In this article, we are going to discuss the use of excel function keys (F1 to F12). Function Keys in Excel are a handy and faster way of doing certain tasks by using the keyboard instead of a mouse.

List of excel shortcut keys