Excel Shortcut – the Power of F4

Here’s a short and sweet tip if you’re working in Microsoft Excel: pressing the F4 key will repeat the last thing you did, in the cell you’re currently in.

I used this today to add extra rows in my data.  I created a list of state abbreviations and wanted a row between each. Here’s how:

  • Right click on the first cell (A1 for me), and select “Insert…”
  • Select “Shift cells down”
  • What was in cell A2 is now in A3
  • Click on cell A3 and press the F4 key
  • What was in A4 will now be in A5!
  • Rinse, lather, repeat!

I got in a rhythm of F4, down arrow, down arrow, F4, down arrow, down arrow, F4… and was able to quickly space out my data.  This can also be used to apply background color to cells, text formatting, and many other things!

Have a question for Today’s Tech Explained?  Let us know!  Our contact form can be found here: Contact Today’s Tech Explained.

Advertisements

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