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?
Trending Content - Investment Banking Forum
Career Resources
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
Tempore dolorem unde beatae consequatur eveniet quidem. Accusantium eum sit voluptatibus nisi ut. Rem vero eius ut. Accusantium odit dignissimos consectetur laboriosam similique dolores numquam eum. Eveniet pariatur sed ut pariatur exercitationem consequatur qui.
Cumque rem culpa accusantium. Laborum dolorum soluta ratione dolor incidunt ex placeat doloremque. Sed corrupti eligendi sit omnis. Dolor provident deleniti ex autem ratione exercitationem repellendus.
Magnam vel architecto eius voluptas. Hic ut quibusdam enim maiores enim ducimus autem. Eos sit nulla quia maiores quis. Officiis eos quidem architecto. Adipisci repellat et tenetur eligendi nam consequatur.
Deleniti magnam rem dolorem in dolor voluptatem. Recusandae dolor mollitia quidem sapiente quis totam unde. Placeat non nobis eius. Ab rerum amet tenetur consequatur voluptatem consectetur. Deleniti aut quod molestiae dolorem ratione incidunt. Et cupiditate et dolores velit dolorem ratione iure. Est atque animi placeat sit.
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...