The Handbook of Financial Modeling: A Practical Approach to Creating and Implementing Valuation Projection Models

Model Housekeeping

In this appendix, I have pulled together a list of helpful tidbits that may prove to be useful in your work with models.

1. Reserve some preliminary columns on every sheet. I would advise that you reserve a few columns to the left that you leave blank. If you later decide to add labels or name references, these blank columns will prove themselves to be useful. I use these columns to provide referencing throughout the model.
2. Hide grid lines. Over the years, I have grown to detest gridlines, possibly because they are set as the default worksheet view and are pervasive throughout the worksheet. I prefer to have more control over ...