logo ASAP Utilities

Tip of the Day | Sunday November 16th, 2025

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

Copy and Apply Certain Cell Formatting Settings...

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.

    Screenshots

    Format & Layout  ›  Copy and Apply Certain Cell Formatting Settings...

    Starting this tool


    Format & Layout  ›  Copy and Apply Certain Cell Formatting Settings...

    Choose your language preference below

    English (us)NederlandsDeutschEspañolFrançaisPortuguês do BrasilItalianoРусский中文(简体)日本語



  • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


    🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
    For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.