ms excel training - styles workbook
Book Your Virtual Classroom Training


starstarstarstarstar Excellent

Forum home » Delegate support and help forum » Microsoft Excel Training and help » ms excel training - Styles on a workbook

ms excel training - Styles on a workbook

resolvedResolved · Low Priority · Version Standard

Wed 20 Jun 2007, 16:57 replyReply Delegate Harriet said...

Harriet has attended:
Excel Advanced course

Styles on a workbook

How do you group a selection of styles on a workbook?

For upcoming training course dates see: Pricing & availability

Thu 21 Jun 2007, 13:49 replyReply Trainer Amanda said...

RE: Styles on a workbook

Hi Harriet

Thank you for your question.

To create a new style:

1. Select a cell that has the combination of formats you want to include in the new style.
2. On the Format menu, click Style.
3. In the Style name box, type a name for the new style.
4. To define and apply the style to the selected cells, click OK. To define the style without applying it, click Add, and then click Close.

Otherwise if you format the sheet how you wish to, then save it as a template, the sheet can be reused multiple times with the same formatting.

To save a file as a template, go to File - Save as and choose .xlt Excel template from the Save as type list before saving.




Live dates & prices


Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


Excel tip:

Shortcut for accessing recently opened files

To get into recently opened Excel files without using your mouse, hold down Alt + F to open the File menu.

Recently opened files are listed down the bottom of the File menu - type in the number next to the file you wish to open and it should appear on your screen.

View all Excel hints and tips

TrustScore 4.8 / 5       1272 reviews