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 of
MrExcel LIVe

A book for people who use Excel 40+ hours per week. Illustrated in full color.