What it does
Allows you to add a formula suffix to any selected cells on the active sheet.

When to use it
When you want to quickly add a formula suffix to the selected range.

Why to use it
It’s a very quick way to add formula suffixes to all the cells in the selected range.

Default shortcut
None

Other Details

• Category: Formulas / Links
• Difficulty: 3/5
• Usage/frequency: 2/5
• Automation factor: 5/5 (estimated 300 seconds saved each time used)
• Type: Bulk
• Date added: 6/28/2026
• Tags: formulas

Related Macros
Bulk Add Formula Suffixes

Other Articles
How to Make a Fake Excel Reference

Add Formula Suffix Example File

Prerequisites
Identify the formula suffix you want to add and the cells you want to apply it to.

Instructions
After you have identified the formula suffix and cells to apply them to, run the Add Formula Suffix macro.  It will prompt you to enter the suffix to add.  If you have set a default suffix, it will be entered by default.  To save your entry as the new default, just check the “set as default” checkbox.  After you enter the suffix, click the OK button to add it to all the selected cells.

If you need to add formula suffixes to several different ranges or several different sheets, use the Bulk Add Formula Suffixes macro.