Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » training ms excel advanced - Cells

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

training ms excel advanced - Cells

Resolved · Low Priority · Version Standard

Reply Wed 1 Aug 2007, 12:57Delegate Peter said...

Peter has attended:
Excel Introduction course

Cells

how do i merge and align cells

For upcoming training course dates see: Pricing & availability

Reply Wed 1 Aug 2007, 15:16Trainer Tracy said...

RE: cells

If you highlight across the cells you wish to merge you can use the Format menu, go to the alignment tab and tick the box towards the bottom of the dialog box which says merge. Once merged you can use the other options on that box to centre the text horizontally across the cells.

There is also a button on your formatting toolbar which merges and centres. It looks like a lower case 'a' with two arrows pointing away from the a. Like this
<--a--> if you find it that does the same job!

regards

Tracy

Excel articles

· Identifying Suitable Candidates For VBA For Excel Training
· Unsupported features in Excel 2007
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· Excel Offers A More Relaxing Way To Work Out
· A Picture Is Worth A Thousand Words (Or Numbers)

Excel tip:

Quickly copy a formula across sheets

Suppose you have a formula in cell Sheet1!B2, say =A1*5%, that you wish to copy to cell B2 on Sheet2, Sheet3 and Sheet4. Instead of using copy and paste, try this: (1) Select Sheet1!B2. (2) Group Sheet1 with the worksheets Sheet2, Sheet3 and Sheet4 by holding down Ctrl and clicking on the tabs of the sheets to group them. (3) Press the F2 key, then immediately press Enter to copy the formula in Sheet1!B2 across the grouped sheets.

Remember to ungroup the sheets afterwards! Right-click on any tab and choose Ungroup Sheets to do that.

View all Excel hints and tips