How to repeat an action in Excel

TrustPilot

starstarstarstarstar Excellent

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

 

 

Live dates & prices

 

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.


TrustPilot
TrustScore 4.9 / 5       1108 reviews