Quickly Change Formatting in an Excel Worksheet
To copy the formatting, use the Format Painter. Click the Format Painter icon to copy and apply formatting. To repeatedly copy formatting: Double-click the Format Painter icon to repeatedly apply formatting.