How to repeat an action in Excel

Forum home » Topics » How to repeat an action in Excel

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:

Excel - What are F buttons for?

What are all the F buttons for?

Read forum post


What is a Macro?

I have heard the mention of Macros and it is a term I have heard used, but what exactly is a Macro?

Read forum post


Benefits of macros in a spreadsheet?

How does macros benefit a spreadsheet

Read forum post



Training courses


Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Server loaded in 0.09 secs.