Home Article index Newsletter

Deze pagina in het NederlandsHome > Article index >

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

  1. How Styles Work
  2. Creating Styles
  3. Applying Styles
  4. Deviate from a style
  5. Tips
  6. VBA Examples
  7. Conclusion


Comments

All comments about this page:


Comment by: Mike Woodhouse (5-2-2009 10:12:56) deeplink to this comment

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 (6-2-2009 02:46:37) deeplink to this comment

Hi Jan,

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

Regards
Kanwaljit


Comment by: Jan Karel Pieterse (6-2-2009 04:03:16) deeplink to this comment

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 (9-2-2009 11:29:04) deeplink to this comment

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, will only be used to inform you when your comment is published or to respond to your question directly):

Your request or comment (max 2000 characters):

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

I give permission to process this data and display my name and my comment on this website accoring to our Privacy Policy.