Most Valuable Professional


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

Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.

Speed up your file

FastExcel
The best tool to optimise your Excel model!
Home > English site > Articles > Styles in Excel
Deze pagina in het Nederlands

Styles in Excel

This article has also been published on Microsoft's MSDN site:

Using Styles to Dress Up Your Worksheets in Excel 2007

Introduction

This article explains how you can use styles to ease maintenance of your spreadsheet models.

Microsoft has made it very easy to dress up your worksheets with all sorts of fill patterns, borders and other frills. Because formatting of cells is often done in an ad-hoc manner, many spreadsheet pages look messy.

By consistently using cell styles (instead of changing parts of the cell's formatting) you will be forced to think about the structure of your work. Religiously using styles may even force you to reconsider the overall structure of the entire spreadsheet model: The quality of the computational model itself may be positively affected.

I therefore consider Styles as being underused, underestimated and under exposed.

Content


Comments

All comments about this page:


Comment by: Mike Woodhouse (2/5/2009 10:12:56 AM)

Yes!

This is another superb Office feature that Microsoft failed adequately to publicise. I only discovered it myself when I was complaining that Excel should have something like Word's styles. Then I found that it did.

I guess this is one of those things that the Ribbon was supposed to help users discover. I wonder if it works?

 


Comment by: Kanwaljit (2/6/2009 2:46:37 AM)

Hi Jan,

Thanks for the great article.How can we take a print out of this ?

Regards
Kanwaljit

 


Comment by: Jan Karel Pieterse (2/6/2009 4:03:16 AM)

Hi Kanwaljit,

I may create a pdf version of this in future, but for now there is no time. Good idea though.

Regards,

Jan Karel

 


Comment by: Jan Karel Pieterse (2/9/2009 11:29:04 AM)

Hi Kanwaljit,

The last page of the article has a download link.

 


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].