Function Keys in Excel are a handy and faster way of doing certain tasks by using the keyboard instead of a mouse. In this article, we are going to discuss the use of excel function keys (F1 to F12). Function keys provide the same output in all versions of Excel making it easier to recall. Show
Before we head onto our topic, let us first know about the history of function keys and how do they work. How Function Keys WorkFunction Keys generate fixed, single byte code that is outside the range of normally used ASCII Codes. These ASCII Codes are interpreted by the application program like Excel, Word, Paint, etc. 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. History of Function KeysIt might amaze you to know that the original "Personal Computer Keyboard" from IBM in 1981 had only 10 Function Keys, F1 to F10. The concept of 12 Function Keys was introduced 31 years ago, in the year 1984 by using Model M type of Computer Keyboards. Now let’s jump to our topic, "Excel Function Keys" to get an insight about all the 12 Functions and how to use them. We will also be discussing the output given by using function keys with Alt, Shift, and Ctrl Keys. This is a long post of around 3000 + words. 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. Excel Shortcut Keys Table
F1 Key"F1" is used for opening "Excel Help". Its output is same as obtained by clicking on "question mark button" available on top right hand side of your excel sheets as highlighted in below image.
|