Did you know that F4 repeats the last command if it is possible? If you are coloring, F4 repeats the last color or formatting.
For example, I use it when I look at a larger lists and highlight the problematic data in yellow. This is much easier to press the F4 button than to always click on the “bucket”.
In the Cell Format (Ctrl 1) panel, you can specify more advanced formatting, – e.g. border, font style, font size – and the F4 button will repeat it all.
Ctrl Y does the same thing if you use it alone – not after Ctrl Z = undo.
If you want more help, don’t hesitate to try the private Excel course via Skype. We will help you know Excel better and use it in a more effective way. You will be very grateful for the time you can save.