F1 to F12 are always sitting on the keyboard quietly. How often do you use them?
In the era of Google, you may find what you need by simply searching something like “Function keys in Excel”. Then you will probably be overloaded by the huge amount of pages found. (Well, that happens to every search…)
When you look into the top few pages, you will likely find a list of shortcut combinations for F1 to F12 in Excel, mostly in written texts. Unless you know Excel quite well already, there is a high chance that you still do not understand what the Function keys do in Excel after reading the descriptions. For example:
F8: Turns extend mode on or off. In extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection.
Source: support.office.com (you may find a list of shortcuts there)
Do you really understand what F8 does after reading the above?
To celebrate the 2nd Anniversary of this blog – wmfexcel.com (the first post was published on September 7, 2013, time really flies!), I am going to write a series of Function Key every Monday, Wednesday and Friday in the coming weeks, one Function Key in one post.
You may wonder why I don’t put all the twelve function keys altogether in one post? The reason is to keep you focused. I believe it’s a better way to learn and get something practical out of it.
Please be ensure that I won’t simply copy and paste the lists to my posts. Instead, I will try to incorporate texts (inevitably) with screenshots for better illustration. And of course, I will add my comments and tips in usage, whenever possible.