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

Auto-Generated Transcript

  • Learn Excel from MrExcel Podcast Episode
  • f4 to repeat let's say that we have some
  • data here and our manager is one of
  • those evil managers and what's the tiny
  • little columns between the columns and
  • so I figure out the keyboard shortcut
  • for insert column all I see all right
  • 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 one all right so also CW
  • one all right now the last thing that I
  • did is format column width one 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 the
  • 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
  • vitals you next time for another nut
  • cast 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.