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?
| +366 | Don’t work at UBS - UBS Sucks | 35 | 42m |
| +326 | Article - UBS’ Investment Bank Keeps Losing Ground | 41 | 17h |
| +107 | Should My Intern Get a Return Offer? | 44 | 2h |
| +60 | When to Leave Office as Intern | 8 | 3d |
| +54 | Best IB Group Overall? | 30 | 12h |
| +39 | Would you rather be a Touse Squid or a Bouse Mogger in IB | 2 | 3d |
| +33 | What do you say to ppl who don’t know EVR/LAZ/CVP/PJT | 28 | 1d |
| +33 | F*ck it I'm Going to Med School | 14 | 5m |
| +31 | STEM student lost in London IB recruiting | 17 | 2d |
| +26 | [HELP REQUESTED]: Take A2A Promo or Go Corp Dev | 9 | 3h |
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.
A voluptatum sit quae eum quisquam iure quis. Laudantium rerum impedit corrupti quam corporis nemo maiores. Libero doloremque voluptates est rerum quia voluptas repellat. Doloremque voluptatem repellat pariatur esse velit. Et beatae facere sapiente voluptatum odio quaerat. Praesentium quaerat inventore aut debitis.
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...
Velit illo nobis quisquam ipsam. Officiis sit cupiditate quia temporibus ea ipsum in. Voluptate expedita et perferendis debitis. Rerum deserunt qui enim inventore. Ipsa suscipit iusto neque quibusdam aperiam explicabo earum. Dolorem minus mollitia deleniti perspiciatis. Est dolore atque iure fugit ipsa earum labore.