White solid fill in model?
I've seen some variance in this. Let cells be cells, or white solid fill the workbook?
Trending Content - Investment Banking Forum
| +374 | Which Offer to Accept: UBS Analyst Role or Part Time Cashier at the Local Taco Bell | 44 | 3h |
| +291 | Roku-Fox Deal - UBS Misses Out on yet another deals after years chasing this deal | 31 | 3h |
| +269 | AI is insane | 37 | 2h |
| +264 | I Snuck Into UBS Office And Took A Shit On The Floor | 26 | 6h |
| +254 | TPH V.S. Mizuho [HOU] | 32 | 2h |
| +220 | Best Power/Renewables/Energy Teams? | 35 | 1h |
| +202 | Useless associates | 36 | 2h |
| +184 | Differences in Restructuring Teams? | 33 | 3h |
| +182 | Actual EB List | 26 | 22m |
| +177 | Centerview HC group falling off? | 28 | 3h |
Career Resources
Take the grid lines off for the love of god. I used to be skeptical, but can't even turn back now after seeing how nice an excel file looks without grids. I usually do this after I've built out everything btw, not from the very beginning.
Alt w v g
White solid fill slows a workbook down a lot. No fill and remove the gridlines.
Same thing works if I’m doing conditional formatting for a lot of data. I’ll make the rule in one cell and then copy paste formats to the cells at the very end. You’ll see a big difference in the larger books vs smaller
grids stay out. period
Alt w v g
Well that's one fast solution. Does the setting hold for when you share with others?
Oh man, I didn't know you were actually white solid filling the entire workbook. No worries, yes alt w v g is the right way to do it. This points to how sometimes in banking when you learn things on your own, you end up learning the wrong way and then you carry that with you for potentially a long time. Definitely happened to me too.
To answer your question, it does save that when you share with others / when you open the workbook again.
Earum reprehenderit voluptas fugiat beatae eum ratione non. Eveniet eos voluptate dolores dolorem dicta voluptatem. Itaque sint et consequuntur. Voluptatem in consequatur illum. Aut aspernatur doloribus enim.
Beatae pariatur ullam aut. Earum sint aspernatur aut tempora molestiae praesentium sequi fuga. Eos repellendus ipsa eos a maiores possimus est. Porro assumenda eius in voluptates molestiae et consectetur et. Corrupti et aut quaerat numquam consectetur consequatur. Quia qui rerum quia voluptate.
Harum harum esse explicabo. Occaecati sit iste impedit quas quam. Numquam mollitia hic reprehenderit nihil. Omnis sunt in voluptate nobis ratione odio.
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...