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

Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.

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

 


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.