repeat F4
I have just formatted the borders on an area. Now I want to redo the formatting on another area. So I highlight the area I want to repeat the formatting and then press F4.
F4 repeats the last command in Excel. This applies to most actions in Excel. It will not apply to macros.





