Channel: MrExcel.com

Category: Howto & Style

Tags: excelexcel tutorialexcel online fails when you try to repeat using ctrl+yexcel uses f4 for redo or repeat last commandmrexcelexcel shortcut keysusing the f4 key to repeat in excelexcel online fails when you try to repeat using f4microsoft excelbill jelenexcel keyboard shortcuts

Description: 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