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.

Launch Excel. Open the Excel worksheet you want to format. Click the "Page Layout" tab. Click the "Themes" icon. Select and click a theme from the list. Click inside the cell you want to format.