Excel Modelling Formatting Question
Seen this formatting below, where there is a break in the border between consensus estimates and extrapolation, but I can't figure out how to do it... Tried adding a grey border between but wasn't thick enough. Any ideas how it's done?
It’s done through the ‘single accounting’ underline format. Use Crtl+1 to get to the format menu (while highlighting the columns you want to underline, in this case the 3yrs), toggle to Font, then under the underline menu, click single accounting. Press OK on bottom right and you should be set.
Then do the same for the projection period. It will create a small gap between the borders as you see in your screenshot. Lemme know how it goes!
You absolute hero, thank you so much!! was driving me nuts
Voluptatem facere ab eveniet aliquid ut sapiente doloremque quae. Facere quo placeat et illum autem laudantium.
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...