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
| +135 | UBS Accused of Favoring H-1B Workers While Cutting U.S.-Born Employees | 24 | 9h |
| +90 | Incompetent and annoying co-intern | 23 | 1d |
| +71 | Getting Laid in IB? | 29 | 4h |
| +67 | Intern keeps sleeping at work - what to tell them | 28 | 1d |
| +56 | Living in greenwich as an analyst? | 12 | 1d |
| +47 | UBS Promotion or Lateral to Boutique? | 9 | 12h |
| +42 | NYC Associate Budget | 14 | 1d |
| +39 | PJT M&A Group Selection 2026 | 5 | 13h |
| +36 | Nauseous every morning for past 3 years in IB, anyone else? | 21 | 2d |
| +36 | Quick Thoughts on CVC AI Sale Process | 7 | 1d |
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.
Aperiam aut ipsum voluptas omnis. Sed vitae qui et quam fugiat ratione soluta. Esse omnis ab dolorum qui quia dolore vitae. Molestiae in odit similique quo. Maxime nesciunt aut recusandae mollitia.
Qui est alias voluptate veniam. Earum et nemo debitis itaque iusto.
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...