How to create a list of placeholders

It's time to address all the things we told ourselves we'd come back later and fix.

The ability to create them and then forget about them is one of the things that makes placeholders so valuable. It's the freedom and confidence of "not having to remember to come back and fix this later."

To have this freedom, we need to have the confidence that we can, at any time, get a list of every placeholder in the model. In this way, the model is doing the remembering for us.

Finding all the placeholders can be done manually by searching on square brackets. Since every placeholder has [square brackets around the label], we only need to search on the square brackets.

We have included a macro in the Productivity Pack to scan your model and create a list of placeholders.

The keystroke to create the placeholder list is:


The macro will request you to confirm the row label column in your model. In our models, this is often column E. It can vary where we have created a bespoke column structure for a particular model.

Once you confirm, the macro will scan the model and create a new sheet with a list of placeholders. If you had any cell comments in the placeholders, the macro would pull those into the list.

The list includes a link in Column F. This allows you to jump straight to where the placeholder is in your model using Ctrl+[ or Ctrl+Shift+j. Notice also that the macro has pulled the cell comment into Column H.


Sign in or become a Financial Modelling Handbook member to join the conversation.
Just enter your email below to get a log in link.

Subscribe to Financial Modelling Handbook

Don’t miss out on the latest financial modelling guides. Sign up now to get access to the library of members-only guides.