Formatting

The Formatting section controls the visual presentation of every worksheet in the generated Excel model. These settings affect readability, navigation, and the overall professional appearance of the output file. While they do not change any calculations or data, good formatting makes the difference between a model that is pleasant to work with and one that frustrates its users.

Settings

Conditional Formatting

Conditional formatting applies color-coded rules to cells based on their content or context. When enabled, the generated model uses visual cues to highlight important information automatically.

What conditional formatting does:

Negative values are highlighted (typically in red) so that losses, cash outflows, and unfavorable variances stand out immediately.
Actual vs. Projected periods are distinguished by background color. Historical periods that contain real data use one color scheme, while forecast periods use another. This visual separation reinforces the distinction between verified results and estimates.
Section headers and subtotals receive distinct formatting to improve the visual hierarchy of financial statements.

Recommendation: Keep conditional formatting enabled for most use cases. It significantly improves readability and reduces the risk of misinterpreting data. You might disable it only if you plan to apply your own custom formatting to the output file or if you are importing the data into another system that does not benefit from cell formatting.

Freeze Panes

Freeze Panes locks specific rows and columns in place so they remain visible as you scroll through large worksheets. When enabled:

Header rows (containing period labels and column titles) stay visible as you scroll down through account rows.
Label columns (containing account names and codes) stay visible as you scroll right through period columns.

In a financial model with many periods (monthly data over five or more years can produce 60+ columns), scrolling to the right without frozen panes means losing sight of which account you are looking at. Similarly, scrolling down through a long chart of accounts without frozen headers means losing track of which period each column represents.

Recommendation: Always enable Freeze Panes. There is virtually no downside, and it dramatically improves navigation in any model with more than a handful of rows or columns.

Zoom

The Zoom setting controls the default zoom level applied to all worksheets in the generated model. It accepts values from 50% to 200%.

Guidance by use case:

| Zoom Level | Best For | |------------|----------| | 50-70% | Large models where you want to see many columns at once on a wide monitor | | 75-90% | General-purpose use on standard monitors | | 100% | Default Excel zoom; comfortable for reading but shows fewer columns | | 110-150% | Presentations on projectors or large screens | | 150-200% | Accessibility needs or very small screens |

Recommendation: A zoom level of 80-90% works well for most financial models, balancing readability with the ability to see a meaningful number of periods on screen. If your model uses monthly periods (many columns), a lower zoom around 70% may be more practical.

How Formatting Interacts with Other Settings

Formatting settings work alongside other configuration sections:

Reports — report worksheets inherit all formatting settings. The Values Divider from Reports determines the numbers that conditional formatting evaluates.
Charts — chart sheets have their own visual style and are not affected by conditional formatting or freeze panes.
Analysis — consolidation worksheets use the same formatting rules, ensuring visual consistency across working sheets and summary sheets.

All formatting is applied during the build process. The generated Excel file opens with these settings already in effect. Users can modify formatting in Excel after generation if needed, but starting with a well-formatted baseline saves significant manual effort.

Tips

Test different zoom levels by generating a sample model and opening it on the same display you will use for analysis. The right zoom depends on your screen size and resolution.
Leave conditional formatting on during model development to catch unexpected negative values or data entry errors early.
Use Freeze Panes with every model. Navigating a financial model without frozen headers is like reading a spreadsheet without column labels.