How to color few cells with the same color without clicking the fill color button

Hi! Okay today I am going to reveal the fastest way to color cells with the same color without click the fill color button and the cells back and forth.

Okay now. Let say you want to color all of number 1 to yellow.



You can start by coloring the first number 1 as usual.

For the rest of number one, instead of clicking back and forth the cell and the fill color button, you can just activate the cell that you want the color to be changed to yellow and effortlessly press F4.

Easy! :). Actually F4 is a shortcut key to copy last action made by you. Eg: If let say the last action was deleting Row. You can easily delete another rows by selecting the row and pressing F4. Without having to right click and select delete row.

Have fun trying. :)