Tip of the Day | Saturday 11 July 2026

This tool lets you copy specific formatting settings from one cell and apply them to other cells in your worksheet.

Unlike Excel's Format Painter, which copies all formatting at once, this tool gives you complete control.
You can choose exactly which formatting options to copy and apply.

You can copy one or more of the following formatting settings:

• Number format
• Font
• Font size
• Font style
• Bold/underline/italic
• Font color
• Horizontal alignment
• Vertical alignment
• Text orientation
• Wrap text
• Cell color
• Cell pattern
• Cell pattern color
• Locked
• Hidden

The All, Invert, and None buttons allow you to quickly choose which settings to copy.

You can choose to copy formatting from:

• A specific cell in your worksheet
• The standard formatting profile

The formatting can then be applied to a selected range.
Your last used settings are automatically remembered for quick reuse.

This tool is helpful when you want more flexibility than Excel's Format Painter, especially when working with complex formatting or selectively applying styles without affecting everything.

Starting this tool