The F4 key in Excel has a dual life. Most people know F4 as the way to put dollar signs in a formula reference. But when you are not editing a formula, F4 will repeat the last command.

Some of you know this as Ctrl+Y, but F4 also acts like Ctrl+Y and is easier to press (for me, anyway).

Today, I had an odd problem where I had to delete every other column for 10 columns. Instead of writing VBA, it is faster to do the first delete for Alt+O, C, H and then repeat with F4. Right-arrow twice to the next column and F4 again. It is a quick solution.

There are so many solutions where F4 is useful.

This episode also takes a trip over to Excel Online.

Excel Online is an experimental version of Excel running in a browser, meant to compete with Google Sheets.

Thanks to Wyn Hopkins for pointing out that Excel Online has a searchable list of Excel Keyboard Shortcuts.

That list says that F4 is repeat in Excel Online, but it does not work here.

Table of Contents
(0:00) Using F4 to help delete every other column
(1:49) Switching to Excel Online
(2:24) Searchable list of Keyboard shortcuts in Excel
(3:29) F4 fails in Excel Online
(3:57) Ctrl+Y fails in Excel Online
(4:34) Excel courses on Retrieve platform