While typically used to copy both content and format, Ctrl + R (Fill Right) is a keyboard-centric shortcut that facilitates the L-R flow. If the destination cells are blank, it copies everything; if they contain data, it overwrites. This is the primary shortcut for rapid horizontal population.
Merged Cells and Hidden Columns/Rows
Excel’s fill handle (the small square at the bottom-right of a selected cell) can copy formatting left to right when used with (Fill Right). l r copy format in excel
