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
Veniam nam nihil quaerat perferendis. Impedit et nostrum amet quidem tenetur quos facilis. At eos molestiae tempora. Enim ab et cupiditate quis aut ex illo. Voluptates iste id aut quidem voluptas porro. Officia dolorem cum eos illo repellendus eveniet. Distinctio aliquam sunt delectus adipisci.
Quo autem sunt velit odit dolorem. Quae sunt cum velit reprehenderit. Temporibus voluptatem reprehenderit omnis sint alias velit dolorem. Voluptatem minima ipsum voluptatem labore aliquam similique facere. Nulla voluptas iusto ipsa facilis quo.
Iusto tempora et incidunt aut. Eum in libero ad unde animi quod harum.
Sit ut nisi ipsum aut odit suscipit. Repudiandae qui excepturi deleniti sequi. Pariatur ullam numquam exercitationem quibusdam.
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...