What it does
Uses a settings sheet (Bulk_Add_Formula_Suffixes) to add a suffix to one or more ranges/sheets, in one bulk step.

When to use it
When you want to quickly add a formula suffix to several ranges throughout a file in one bulk step.

Why to use it
It’s a very quick way to add formula suffixes to multiple ranges/sheets throughout a file in just one step.

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, bulk

Related Macros
Add Formula Suffix

Other Articles
How to Make a Fake Excel Reference

Bulk Add Formula Suffixes Example File

Prerequisites
Identify the formula suffixes you want to add and the sheets/ranges you want to apply them to.

Instructions
After you have identified the formula suffixes and sheets/ranges to apply them to, run the Bulk Add Formula Suffixes macro.  The first time you run it, it will create a sheet called Bulk_Add_Formula_Suffixes.  This is where you’ll specify the formula sheets, ranges, and suffixes.  After filling in the values, run the Bulk Add Formula Suffixes macro again to process the contents.  These are the fields in the Bulk_Add_Formula_Suffixes sheet that you’ll want to fill in:

• Column A – Sheet name  (required): enter the name of the sheet containing the range to add a formula suffix to.
• Column B – Range name/address (required) – enter the range address/name to add a formula suffix to.
• Column C – Formula suffix (required) – enter the formula suffix you want to add.

If you only want to add one formula suffix, you can also use the Add Formula Suffix macro.