MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Shortcut - F4 to Repeat

August 24, 2017 - by Bill Jelen

Excel Shortcut - F4 to Repeat

My favorite shortcut in Excel is F4 to Repeat the Last Command. If you are stuck with deleting hundreds of tiny columns between the columns, this command is awesome.

Watch Video

  • New feature July 2017 - Provide Feedback with Sounds
  • Choose the Modern Sounds
  • Opening a Pane, Closing a Pane, Autocorrect, Copy, Undo, Redo, Paste, Saving a
  • Document, Deleting Cells, Inserting Cells, Deleting Rows, Deleting Columns

Video Transcript

Learn Excel From MrExcel, Podcast Episode 2138: F4 To Repeat.

Let's say that we have some data here and our manager is one of those evil managers who wants the tiny little columns between the columns, and so I figured out the keyboard shortcut for insert column, ALT+I, C, alright? Now, I need to insert a column in all of the other columns, before all the other columns. The last thing I did was insert column, so if I come here and press F4, it will insert column. F4, F4, F4, F4. See how fast that is?

And then the other thing I have to do is I have to format the column width as 1, alright? So, ALT+O, C, W, 1, alright? Now, the last thing that I did is format column width 1, so if I go to the next column, press F4, press F4, press F4, press F4, press F4, and you can repeat that action very quickly.

F4 or CONTROL+Y is essentially the same as clicking redo but it's faster than clicking redo. Break your task down into tiny little pieces that could be repeated over and over and over, and you will be able to do things quickly, quickly using F4.

Thanks for stopping by. We’ll see you next time for another netcast from MrExcel.

Title Photo: aitoff / Pixabay

Bill Jelen is the author / co-author of
Excel Dynamic Arrays Straight to the Point

The new Dynamic Array Functions are just one side-effect of an effort to completely rewrite the Calculation Engine in Excel. Joe McDaid and the rest of the CALC team have the laid the groundwork for all future functions in Excel. Yes, the first crop of SORT, SORTBY, FILTER, UNIQUE, SEQUENCE and RANDARRAY are awesome and powerful, but they are just the first of many new functions that will come to Office 365 over the coming years.