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). So, what are these shortcut keys that we should know? According to our experience, these are those you probably will use more often.Function Keys in Excel are a handy and faster way of doing certain tasks by using the keyboard instead of a mouse.

If you have memorized and mastered these shortcut keys usage, you should be able to finish your excel work much faster! That is because we often need to perform their functions in our work in excel. From the many shortcuts that excel has, some are probably more important and useful than others.

Formula excel shortcut keys