L R Copy Format In Excel [2021] -

The formatting from the left column is now replicated across all selected cells to the right. Importantly, this method preserves the destination values and formulas.

Applying a Single Formula Across Multiple Adjacent Columns l r copy format in excel