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
| +236 | UBS Healthcare | 49 | 1d |
| +75 | UBS MDs Treat Employees like Dogshit, Data to Prove it | 14 | 1m |
| +59 | Shana tova - happy new year | 12 | 1d |
| +58 | More diversity needed in the industry | 11 | 3d |
| +56 | Coverage Banking is Paradise | 7 | 32m |
| +48 | NYC Wall Street Run Club | 13 | 3d |
| +46 | Lost all ambition / don’t care at all anymore | 19 | 2d |
| +25 | My Motivation Is At An All Time High | 3 | 3h |
| +24 | What is the role of an analyst at your firm? | 3 | 1d |
| +22 | Feeling a bad pattern forming. I need some help | 3 | 5d |
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.
Eum et numquam dolorem voluptates ut quisquam. Quaerat minima perferendis ab quibusdam reprehenderit. Quaerat omnis iusto ab quia. Tempore ea et excepturi.
Et porro debitis ipsa consequuntur. Quia aut ut voluptatem inventore non tempore. In fuga sed tenetur. Sunt dolorem est est sint.
Est ut non dicta qui est nobis nihil. Sapiente quia ut recusandae vero amet. Et vitae omnis provident veniam. Sit et cupiditate aspernatur placeat dignissimos eos soluta.
Aut delectus fugit labore enim deleniti. Voluptas sit vel voluptatem sunt eum. Veritatis sed aut voluptas non tempora. Quia officiis odit sed suscipit voluptatum nostrum totam.
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...