Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

ResolvedVersion 2003

Thu 12 Feb 2009, 09:41 Delegate Gillian said...

Gillian has attended:
Excel Intermediate course

Excel

whats the advantage of styles?

Thu 12 Feb 2009, 13:45 Trainer Amanda said...

RE: Excel

Hello Gillian

Thank you for your question and welcome to the forum.

A style is simply a group of formats (e.g. font, font size, font colour, shading, alignment) that have been saved under a name.

The idea is that you can then apply the style to a cell or cells in the spreadsheet to apply the various formats that are part of the style all at the same time.

It also ensures consistency as the same formatting is applied each time the style is used.

I hope this helps.
Amanda

Thu 19 Feb 2009: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Make macros work in newer versions of Excel

If you have created macros in Excel 97 or 2000 that you want to be able to use in 2002/XP or 2003, you may need to alter the macro security settings in the newer version of Excel you are using.

To do this, go to Tools - Options - Security.

Select Macro Security and change the security setting to Low.

Tick the boxes next to 'Trust Add-ins' and 'Trust Visual Basic' and click OK.

After you have restarted Windows, you should then be able to use your macros created in earlier versions of Excel.

View all Excel hints and tips

Excel

Excel

RE: Excel

Excel articles

Excel tip:

Make macros work in newer versions of Excel