Separating columns is an important aspect of having a nicely formatted comps header. I have seen a few ways to format comps headers:
Personally, I like using single accounting underlines and when I input years I always put (E) or (A) at the end.
What is your preference?
| +905 | Bank of America - Juniors Strike to start Monday May 6th | 122 | 11m | |
| +546 | BOFA ALREADY TRYING TO COVER UP THEIR TRACKS | 72 | 48m | |
| +309 | This is a dark day for Wall Street. | 33 | 22m | |
| +154 | Investment Banking US League Table YTD 2024 (FactSet) | 85 | 5h | |
| +147 | Big Layoff at Barclays - 5/1/24 | 85 | 10h | |
| +90 | “Americans just work harder” | 54 | 3h | |
| +83 | Would comitting to ATL İB be stupid? Please give feedback. | 45 | 3d | |
| +69 | Sleeping on Jefferies??? | 35 | 3h | |
| +66 | A shitter's comprehensive guide to sophomore year recruiting | 8 | 1h | |
| +60 | What's up with RBC nowadays? | 28 | 2h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Used to underline with single-accounting, recently switched to thick white borders.
2 rows
Top row: Values are regular dates, e.g. 1/1/18. This enables the use of eomonth, sumifs, etc. Number format is yyyy"P" or whatever.
Second row immediately below it: Change height to something small. Alt H B P, then Alt H B M, add white, thick (second from the bottom-right option) borders on the left and the right of the cell.
Why do this instead of just single accounting underline? If the value in the cell is just a value, then single accounting underline will only underline the value and not the entire cell. This won't.
Explicabo dolorem dolores ut consequatur. Et voluptas cumque nihil iusto aut. Itaque sunt inventore nisi sed soluta.
Et laborum assumenda dolores amet. Autem atque possimus eum voluptatem sunt culpa. Rerum nihil expedita sit omnis alias ut consectetur. Maxime iusto modi sit et ipsam a possimus. Tempore ut voluptatibus vitae deleniti. Architecto amet qui fugit natus.
Quas voluptas cupiditate libero odit officia aliquid. Est eligendi sunt officiis explicabo minus occaecati. Omnis qui voluptatem velit temporibus culpa ut aut est.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...
Quae consequuntur nobis sed rerum reiciendis doloremque ut. Temporibus similique culpa aut qui consectetur. In exercitationem esse voluptas vel est enim. Quam voluptas debitis rem adipisci facilis accusantium veritatis possimus. Aut voluptate beatae voluptatibus aut deserunt necessitatibus doloremque.
Dolor quis et dolorum repellendus qui vero. Aut voluptate eius molestiae hic aliquam maiores. Veniam voluptatibus aut sint aspernatur consequatur est nostrum.
Qui totam placeat exercitationem quia excepturi distinctio. Dolorem illum error totam blanditiis quibusdam ut est. Qui dolor aperiam dicta culpa. Distinctio quasi rerum et id. Harum enim beatae fugiat cupiditate.