Repeating Excel formatting functions with F4

This is a cool feature that I was unaware of… you can use F4 to repeat a formatting function in Excel. I tried out the F4 repeat on a couple of cell formats, and it works pretty well. Here’s how…

Here’s an Excel spreadsheet where I’ve highlighted an individual cell in yellow. I place my cursor in a blank cell and click F4:

excel-f4functionrepeat-20190219-1

The cell where I clicked F4 is now also highlighted in yellow:

excel-f4functionrepeat-20190219-2

In this example, I typed text into a cell that overran the width of the cell, and I used Home > Wrap Text to reformat the cell to keep everything within the given width of the cell:

excel-f4functionrepeat-20190219-3

Once that was complete, I clicked into another cell and used the F4 function to copy the same formatting function into that cell:

excel-f4functionrepeat-20190219-4

Now when I type in that cell, the text wraps automatically:

excel-f4functionrepeat-20190219-5

And when I hit enter, the cell expands vertically to show all the text I entered:

excel-f4functionrepeat-20190219-6

Leave a Reply

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 )

Google photo

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