99.4% Of all customers recommend us, we're so confident about our results we publish all reviews and statsView Live Stats View Reviews
How to repeat an action in Excel
To repeat an action in Excel, you can use the F4 function key or CTRL+Y.
Let's say you had applied Bold to the data in cell A1 and then decided to make cell C1 bold, simply click on C1 and press F4. This will then repeat the last action which was applying bold to the data in cell A1. In order for this to work properly you must press F4 immediately after an action that you wish to repeat.
Alternatively you could record a macro to automate the repetitive action you are trying to carry out or write some code in VBA.
Using shortcuts or macros in Excel will always speed up your work and from a business point of view improve your productivity.
Related forum posts:
What are all the F buttons for?
I have heard the mention of Macros and it is a term I have heard used, but what exactly is a Macro?
How does macros benefit a spreadsheet
Welcome. Please choose your application (eg. Excel) and then post your question.
Our Microsoft Qualified trainers will then respond within 24 hours (working days).
Any suggestions, questions or comments? Please post in the Improve the forum thread.