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

98.7 % recommend us More live stats...