F4, One Of Microsoft Excel's Hidden Gems
This may be the best keyboard shortcut in Excel
This is one of those rare shortcuts in Excel that is so useful, it's amazing that it is never mentioned in basic training. As a matter of fact, I've rarely heard it mentioned anywhere. That's why few Excel users ever use it.
This simple Excel keyboard shortcut can save you significant time!!
When you want to repeat the last action that you've just taken, just select the range of cells where you want to repeat it an press F4.
For example, if you have just deleted a row and you want to delete another row, simply select the range where you want to delete the next row and press F4. If you have just added cell borders to a range and you format another range the same way, F4 will repeat the previous action for you. This is often most useful when you want to repeat an action over and over.
Just try it! It works on just about anything you do.
Like many other shortcuts in Excel, this one is also available in other Microsoft Office programs (i.e. Word, Power Point).
You will find many more Excel shortcuts like this at www.TheExcelAddict.com?link=hubpages
More time-saving tips available at...
- The Excel Addict Blog
Follow Francis Hayes' (The Excel Addict) blog as he shares with you many of the best tips, tricks and tutorials he has learned from working with Excel every day for over 16 years.
- "101 Secrets of a Microsoft Excel Addict" ebook
• 101 Microsoft Excel Tips that you won't find on most other Excel websites. • 107 pages of easy-to-understand fully illustrated tips that will have you quickly promoted to the "Excel guru" at your office.
Get FREE tips for Microsoft Excel at TheExcelAddict.com website