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
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.
Eligendi eum molestiae nisi magni. Officiis quo et rem odio. Rerum provident aut suscipit eum quia ratione saepe. Consequuntur et autem provident cum eos. Cumque totam dolores non nihil. Animi aspernatur et temporibus fuga harum inventore.
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...