• Home
  • About T4L
    • Contact
    • Legal Stuff
  • Subscribe

Tech for Luddites

News, Views, and How-Tos for a Digital World

F4: The Magic MS-Office Key No One Knows About

Last Updated: October 17, 2014

Note: This post may contain affiliate links, which means if you end up buying something from the site it goes to, I may get a commission for the referral. If you are using an ad blocker, some product information and links may not display unless you whitelist techforluddites.com.

Okay, so I imagine there are some people who know about this key (say, a few developers at Microsoft), but anyone I’ve ever shown it to had no idea about its function. And it’s not a key I use often but, when I do use it, I love it!

So what is this mysterious function? Well, when you’re working in MS-Word, Excel, or PowerPoint, the F4 key will repeat the last command or keystroke you just did. It may not be immediately apparent what the advantage of this is, so I’ll provide a few examples of how I use it, and you may find other situations where it comes in handy. (And if you do, I’d love it if you’d let me know so I can share it with others.

Repeat formatting changes.

Let’s say you’ve written a Word document that has several different levels of subheadings and you decide to make changes to one of the levels. For example, in the screenshot below, “From the Contacts page.” and “From an individual member’s profile.” are at the same level.

Now, if I just wanted to unbold the heading, that wouldn’t be too big of a deal. I’d just Page Down through the document, highlight the headings I wanted to change, and click Ctrl + B, a keyboard shortcut I use all the time.

But suppose I wanted to make all those headings red, something I can’t do with a keyboard shortcut? I’d have to Page Down, then move my hand to click the Color button, and move back to the Page Down key again. (Yes, I realize that’s not exactly grueling labour, but I’m all about the efficiency…)

And if you wanted to make multiple formatting changes to each heading, that would be an even bigger hassle, because you’d have to do each one separately each time.

For example, if I wanted to make my subheadings red, a different font, and all caps, I’d have to highlight each heading and do all those commands each time (or do one command for all the headings and go through the document three times).

Instead, with my magic F4 key, I can simply highlight the first heading, open the font dialog box, make all my changes, and click OK.

That applies all those changes at once to the first heading and Word considers that a single command.

So, now, when I want to make all three changes to the next heading, I just highlight it and click F4 and voila! (If you want to try this for yourself and don’t have an appropriate Word doc handy, you can download this one here.)

Note: For those of you who use Styles, you obviously wouldn’t do this—you’d simply change the style definition. (For those of you who don’t use Styles, I plan to write a series of posts about them in the near future.)

Delete non-contiguous items.

I use this one more often in Excel than in Word. Now, the example I’m going to use here is beyond simple, but hopefully you can see how it could be helpful, especially with longer lists.

In this case, I’ve created a list of people’s names with their (made-up) ages.

If, for some reason, I wanted to delete all the men from the list, I could highlight the first name and delete the row, then use the F4 key to delete the other ones.

Now, you may be asking yourself, “why wouldn’t I just use the Delete key?” Well, there are two reasons, actually:

  • In Excel, the Delete key deletes the contents of the cell in the row, but not the entire row. To do the latter, you’d actually have to go up to the Edit menu and select Delete or use the Delete button in the ribbon (depending on your version of Excel), which is not as easy as the one-touch F4 solution.
  • If I’m using my right hand to highlight each row and move down the list, then I either have to keep moving it to hit the delete key, or have my left-hand cross all the way over the keyboard to keep pressing the Delete key. Again, that might not sound like a big deal but, for a long list, that could become rather uncomfortable after a while. With the F4 more on the left-hand side of the keyboard, it’s just a little less awkward.

Align objects.

This is a good one for PowerPoint, although it would work in Word or Excel as well, if you’re using graphical elements in them. Again, using a super-simple sample, the slide below has a number of rectangles in it that I want to align so that each column is aligned to the left and each row aligned to the top.

Like with the other examples, you have to do the first command manually. In this case, since I’m using PowerPoint 2007, I select the five boxes on the left, click the Arrange button, mouse down and highlight the Align link, then mouse over to highlight Align Left.

Without the F4 key, I’d have to do that with each column and row of boxes. Instead, I simply need to select them again and use F4 to repeat the alignment. MUCH faster. (Note that you would still have to repeat the complete steps to do the top alignment for the first row.)

So there are three specific examples of how you can use the F4 key to save you a little time, effort, and frustration. In general, you may find the key helpful in situations where:

  • You’re repeating a command many times, AND
  • The command doesn’t have its own convenient keyboard shortcut (and especially if it involves several steps)

A couple of extra notes:

  • If you interrupt the repeated command with another action, the new one will become the one that is repeated. So, for example, if you’re changing a bunch of heading styles and, as you’re going through the doc, you spot a typo and delete the word, Delete is now the new command that will be repeated.
  • If you’re typing text, the program considers the entire string that’s been entered as a single command, not just the last letter. For instance, if you type “The rain in Spain stays mainly in the plain.” and hit the F4 key, that entire sentence will be repeated, not just the period at the end. I’m not 100% sure this is the case with every version of Word, but it does apply to 2003 and 2007.

Again, if you discover any other situation where you find this feature helpful, please send it along!

Filed Under: How To, MS-Excel, MS-Office, MS-PowerPoint, MS-Word Tagged With: Facebook

If you found this post helpful, maybe your friends will too (hint, hint)!

To receive future blog posts in your Inbox, please fill out the form below.

Individual Posts Weekly(ish) Digest Monthly Newsletter

Comments for this page are closed. You can provide comments or ask questions via email at feedback@techforluddites.com. Unfortunately I cannot guarantee that I will be able to reply to every question I receive, but I will try.

Featured Posts

Streaming Media Players: A Comparison Chart

A comparison of features between the Amazon Fire TV, Roku, Apple TV, and Google Chromecast, including price, supported content providers, and more.

T4L TOP TEN

Stop the Email Threading Madness

Learn how to change your email inbox to list messages in the order they come in.

Windows 10: Change the Default Programs for Opening Files

Learn how to choose which programs you want to use with different kinds of files, instead of the ones Microsoft wants you to use.

Amazon Fire TV Stick vs Roku Streaming Stick+: Which One Is Right for You?

A comparison of the main differences between these two popular and affordable streaming media players.

Send Your Cable TV Signal Wirelessly to Another Room

Product review and how-to for systems that let you get cable/satellite programming on additional TV sets even if there are no outlets nearby.

Post Photos and Videos to Instagram from Your Computer

If, like me, you spend more time on your PC than on your phone or tablet, you can still share content on Instagram.

Create Different Headers in Word

Step-by-step instructions for using section breaks so you can have different headers on different pages of your Microsoft Word document.

Replacing List Bullets with Images Using CSS

Replacing standard HTML list bullets with images can be a great way to tie them into your site’s overall theme and make pages more visually appealing.

Streaming Media: Frequently Asked Questions

Still have questions about how a streaming media player like the Roku, Amazon Fire TV, Apple TV or Google Chromecast works? Find answers here!

Send Messages to People You Don’t Know on LinkedIn

While there are several ways to do this, purchasing an individual InMail is often the best option—and the most difficult to find.

The Twitter Hashtag: What Is It and How Do You Use It?

Learn what this ubiquitous symbol means and how to make the most of it in your tweets.

Privacy Policy

Data collected through forms on this website is used only for the purposes stated up front, e.g. sending newsletters to subscribers who opt in, selling products or services, etc. Tech for Luddites does not share or sell data collected. Learn more from our privacy policy.

Ads and Affiliate Links

Tech for Luddites is a participant in a number of advertising and affiliate programs. This means that if you take certain actions (click through, make a purchase) from links on this website, T4L may receive a commission for the referral. Learn more.

Contact Tech for Luddites

T4L is not currently accepting guest or sponsored posts. To ask a question, share a tech tip, suggest a post topic, or provide general feedback on this site, please email info@techforluddites.com.

Copyright © 2021 Tech for Luddites. All rights reserved. Content may not be copied without written permission.

This Site Uses Cookies

Learn more about T4L's privacy policy.