Most Valuable Professional


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

Subscribe to our mailing list

* indicates required
Newsletter Archive

File crashes Excel!!

Save my workbook!
The best tool for salvaging problematic workbooks.

Events


Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

FastExcel
The best tool to optimise your Excel model!

Repair your file

Stellar Phoenix Excel Repair
Best tool to repair corrupt Excel sheets and objects
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.

 


Comments are temporarily disabled. We expect commenting to be re-enabled on August 1st, 2015

For simple Excel-related questions I advise this site: www.eileenslounge.com.

For projects and other questions, please contact me using my contact form.