I am going to go on the assumption that most of you know already that there is a Redo button in Excel and that you can use CTRL + Y to do the same thing that the button does.
But did you also know that CTRL + Y also has an additional function which is to repeat actions as well as redo? Well it does!
- So if you change the color of your text in cell A2 and want that same thing to occur in cell B3, simply click on B3 and click CTRL + Y.
- Even better, this doesn’t just work on individual cells. You can use this to repeat formatting on multiple cells simultaneously.
- Once you format the fill in cell B3 to green, you can now select the cells, C3, C4, and C5 (C5:C7).
- Click CTRL + Y and the text in those cells will change to green as well.
Easy peasy don’t you think?