Another use of F4 – Repeat LAST action

Excel tips: F4 to repeat LAST action

As mentioned in my previous post, F4 is my favorite keyboard buddy.  It helps you quickly shift between relative reference and absolute reference when building formula; it also helps to repeat your last action when you are not building formula…  so what am I actually talking about?

Think about that you want to apply a set of formats as below to a table:

  1. Font: Arial
  2. Font Color: Blue
  3. Font Size: 12
  4. Inside border – thin dotted line
  5. Outside border – thick black solid line
  6. Number Format – $ (,000) separator no decimal place
  7. Alignment – Center

So you select the table, right click -> Format Cells, then select the formats above.

After you have done it, wait… there are more than ten tables of different sizes you need to apply the same format to… OMG.

Relax!  You don’t have to repeat the tedious formatting steps.  Simply select the table and then press F4, then you realize that the table is formatted exactly the same as the previous.  Just repeat it to other tables.

Excel Tips - F4

Note: F4 repeats LAST action only, meaning if you perform something else before you press F4, the repeated action will not be what you wanted

Wait… Why don’t I simply use Format Painter then???

You are right if all the tables are of the same size, otherwise Format Painter won’t work as you wish.  Don’t’ trust me? Try this out on your own.

Other uses of F4, my habit:

  • Insert/hide/delete column/row
  • Grouping and Ungrouping

What’s your favorite use of F4?  Leave a comment please.  🙂

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 Excel Tips, Shortcut and tagged . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

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

You are commenting using your 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.