What it does
Allows you to quickly insert a formatted value (like stamping a piece of paper), using formats and values you can define with the Set Format Default macro.  Formats include: number format, alignment, font type, font style, font size, font color, border and highlight/fill color.

When to use it
When you want to apply a “stamp” (with precise formatting and value) to your worksheet in one or more cells, this is a quick, easy, and consistent way to do it.

Why to use it
It’s easier and quicker than using the mouse to specify formats and values you use repeatedly as a stamp.

Default shortcut
None

Other Details

• Category: Formatting / General
• Difficulty: 2/5
• Usage/frequency: 3/5
• Automation factor: 3/5 (estimated 3 seconds saved each time used)
• Type: Shortcut
• Date added: 11/11/2017
• Tags: Formats, default, stamp, font, fill, border, color, value

Related Macros
Set Format Default
WP Ref

Other Articles
None

None

Prerequisites
Select the cell(s) where you want to apply the “stamp” (formats and value).

Instructions
With the cell(s) selected per the prerequisites above, run the WP Stamp macro.  It will insert the stamp value and formats you have defined.  That’s it!