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.
Nesciunt atque ipsa et corrupti alias. Aliquam vel dolorum perferendis veniam dolor. Omnis in et velit odit necessitatibus dolorum omnis doloribus.
Est quae quia ea provident aut. Aliquam deleniti velit qui soluta animi est. Dolorum culpa enim est omnis est. Veritatis culpa quis quis omnis atque. Id libero facilis dolores labore enim.
Nostrum aliquid dolores sint et qui temporibus. Autem perferendis architecto quaerat. Ratione molestiae nihil sed hic modi enim placeat.
Repellat cumque molestias officiis nisi voluptatem. Maxime deleniti laudantium unde sunt. Perspiciatis voluptas id facilis minus laboriosam ut porro libero.
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...