Most Valuable Professional


View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Home > English site > Articles > Styles in Excel > Conclusion
Deze pagina in het Nederlands

Styles in Excel

Conclusion

There is a lot to gain by using styles in your Excel work. To name but a few:

With this article I have tried to give insight in the use of styles in Excel. If you have comments, suggestions or questions, please don't hesitate to use the comment form below each page!

Download a pdf version of this article

 

 


 


Comments

All comments about this page:


Comment by: Primo (2/6/2009 3:05:57 AM)

Thanks for this.

If you have a large file and changed from formatting cells individually to using a few styles, could that reduce the size of the file slightly? Would it save any memory?

 


Comment by: Jan Karel Pieterse (2/6/2009 4:02:27 AM)

Hi Primo,

Yes, it could reduce file size significantly, depending on how complex your formatting was and whether you have sheets where control+end takes you way past the really last used cell or not.

 


Comment by: Primo (2/6/2009 5:45:59 AM)

Hi Jan Karel

That's great, this fits right in with my ongoing streamlining and standardising and general tightening up of my Excel projects.

Thanks again, and for all the other help I've had from your site over the last couple of years!

 


Comment by: jacky (8/29/2009 12:22:26 AM)

it is superb I HAVE NO WORD TO SAY ABOUT U R CONCLUSION

 


Comment by: tom (3/26/2010 8:26:12 PM)

just wondering if you know the maximum number of formats in Excel 2003 or at what level to expect problems without using styles?

 


Comment by: Jan Karel Pieterse (3/27/2010 11:06:57 AM)

Hi Tom,

If I recall correctly the limit is 4000. But you may start experiencing problems at lesser than that, I've heard of as little as 2500.

 


Have a question, comment or suggestion? Then please use this form.

If your question is not directly related to this web page, but rather a more general "How do I do this" Excel question, then I advise you to ask your question here: www.eileenslounge.com.

Please enter your name (required):

Your e-mail address (optional but if you want me to respond it helps!; will not be shown, nor be used to send you unsolicited information):

Your request or comment:

To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].