What the Function keys do in Excel?

Excel Tips - Function Keys

F1  F2  F3  F4  F5  F6  F7  F8  F9  F10  F11  F12

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.

Stay tuned! 🙂


About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Shortcut and tagged . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.