Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel consultants - Format

excel consultants - Format

ResolvedVersion Standard

Thu 19 Jul 2007, 14:37 Delegate Louise said...

Louise has attended:
Excel Advanced course

Format

What's the quickest way to set multiple worksheets the same style?

Mon 23 Jul 2007, 10:46 Trainer Tracy said...

RE: Format

Hi Louise,

Thanks for the question.

To select everything click on the button between the column A and the row 1, the button with no name. Then hold your ctrl key down and select multiple sheets. Once that is all selected go to the Format menu and down to Styles and apply the Style you wish. This will be applied to everything!

Hope that helps

Tracy

Excel tip:

Add Text to Displayed Numbers in Excel 2010

To add text to a number in a cell, you need to go to the Home tab on the Ribbon, and click on the Cells group. Select Format Cells from the drop down menu then Custom from the Category list. In the Type box select General. After the word General, enter a space, then opening quotation marks, then the word you want to type and then closing quotation marks. Click on OK and you have your text!

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

excel consultants - Format

Format

RE: Format

Excel articles

Excel tip:

Add Text to Displayed Numbers in Excel 2010