training microsoft excel

training microsoft excel - Xcel

Resolved · Low Priority · Version Standard

Xcel

Tom has attended:
Excel Intermediate course

by - delegate Tom [1 post] (2007 Sep 24 Mon, 13:49) Reply

How do i merge cells?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	1	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
2007	2008 Dec 10 Wed	Bloomsbury	2	book now	£240	£245
2003	2008 Dec 12 Fri	Southwark	6	book now	£214	£230
Full Schedule: See all 96 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: xcel

by - trainer Anthony gold contributer [113 posts] (2007 Sep 25 Tue, 12:11) Reply

Hi Tom. Select the range of cells you want to merge and then either Format - Cells - Alignment and select the merge cells tick box or use the shortcut icon on the toolbar.

Hope this helps,

Anthony

· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· From the Classroom to the Corporate World
· Features of Microsoft Excel that assist in Analysis of Financial Data
· Interesting Lifestyle Applications for Microsoft Excel
· Tips to Facilitate Printing of Excel worksheets

Excel tip:

Showing all menu items

If you go into a pull down menu you usally find that you get a selection of items(this is the default) or sometimes everything. If you only get a selectiopn you have to go to the double arrows at the bottom of the menu and click it to get all of the hidden items.
To turn this off so that you always get everything, go to Tools / Customize / Options Tab / "Always show full menus". Make sure there is a tick in the box and you will always have every item.

View all Excel hints and tips

Rate this page: