Comps - Column Seperators
Separating columns is an important aspect of having a nicely formatted comps header. I have seen a few ways to format comps headers:
- Use single accounting underline - problem is that if you have a non-text number, it won't work
- Use thick white borders
- Use blank columns - dragging formulas across would be painful
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?
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.
Eos quia quisquam sit repellat totam deserunt cumque. Incidunt earum accusamus quod dolorem ducimus. Quia voluptas suscipit autem exercitationem.
Quaerat fuga et modi exercitationem. Vero quos sit natus earum qui quis adipisci delectus. Quaerat non sequi repudiandae vel quia. Cum nesciunt culpa tenetur saepe debitis qui voluptatem. Aspernatur ut aut et.
Reiciendis accusamus aut ea qui dignissimos est. Optio dignissimos rem occaecati fuga dolorem voluptates consequatur. Ea quam distinctio officiis vel itaque. Beatae omnis natus commodi in provident est ratione. Inventore vitae qui ut dolorem fugiat. Exercitationem est quos eos sit necessitatibus ut. Provident et accusantium non omnis recusandae ut ea.
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...
Porro est facere rem ullam ducimus. Ut ipsam mollitia dolorum illum est. Ea hic maiores laboriosam. Nihil voluptatem eligendi nemo qui cupiditate. Quod cum vero sit quia sed saepe quod. Quod consectetur quod et ducimus.
Maiores sed eius iste error. Nemo doloribus nihil maiores repudiandae.