How to copy formatting to rows and columns without Format Painter Alternatively, here’s how to copy formatting to an entire row or column without using Format Painter.