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.

This guide will tell you how to automatically create a list of all the placeholders you have left in your model.

This post is for subscribers only

Already have an account? Sign in.


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.