98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum 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
Resolved · Low Priority · Version Standard
Harriet has attended:
Excel Advanced course
Styles on a workbook
How do you group a selection of styles on a workbook?
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.
Amanda
Amanda
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Deleting a range of cells using the autofill handleFirstly, select the range of cells for which you would like to clear the contents. Then drag the autofill handle to the the top left corner of the selection whilst holding down the shift key. Your selected contents should then be deleted. |