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?
| +296 | Return Rates For Interns Are Falling? | 122 | 2h |
| +128 | Article: Why UBS's Asian M&A bankers are thriving and UBS's American M&A bankers are not | 14 | 3h |
| +115 | I am a drunk MD AMA | 39 | 1d |
| +79 | UBS Offer Day | 27 | 11h |
| +64 | VP Lifestyle at Top BB Coverage Groups | 40 | 2d |
| +57 | An Outsider’s View of RX Banking Out of College | 6 | 5d |
| +54 | Evercore > Goldman and I don’t think it’s particularly close anymore | 30 | 1h |
| +42 | I hate Wells Fargo | 10 | 3h |
| +41 | WF Return offers | 28 | 14h |
| +39 | Should I go back into a junior IBD role for comp? | 16 | 10h |
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.
Quos expedita omnis eius veritatis quidem molestias. Ea optio sapiente ut dolores suscipit non. Sint error earum labore unde ipsam dolor. Quia voluptatem ea porro deleniti aut.
Sequi consequatur quaerat mollitia qui esse aperiam deleniti. Fuga ducimus accusamus autem quia voluptates tempore inventore.
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...
Voluptatem ipsam qui officia dolor. Similique sunt reprehenderit veniam mollitia. Nisi porro reiciendis in molestias dolorem ratione sed. Qui voluptas sed et ab non sit aliquam libero.