excel computer training london - Sort data with different size cells

The UK's most regular instructor-led training courses.
Training information: excel computer training london, Excel training london, Microsoft Excel Training · Microsoft courses.

Resolved · Low Priority · Version Standard

Sort data with different size cells

Marjolein has attended:
Excel Introduction course

by - delegate Marjolein [1 post] (2007 Apr 17 Tue, 17:22) Reply

Dear Sir,

I have made a big data base with columns that are named after - Store - City- Country etc.

I would like to sort the data according to the country and normally that works but now, because some of the cells in column A have been merged - it does not seem to work.

Could you help me with this?

Thank you. Kind regards

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course				List price £245
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 May 14 Wed	Tooting	4	book now	£214	£230
2007	2008 May 14 Wed	Bloomsbury	4	book now	£240	£245
2003/XP	2008 May 16 Fri	Southwark	6	book now	£214	£230
2007	2008 May 20 Tue	Bloomsbury	7	book now	£218	£240
2003/XP	2008 May 21 Wed	Southwark	6	book now	£214	£230
2003/XP	2008 May 21 Wed	Bayswater	6	book now	£195	£205
Full Schedule: See all 156 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Sort data with different size cells

by - trainer Amanda platinum contributer [689 posts] (2007 Apr 18 Wed, 11:19) Reply

Hi Marjolein

Thank you for your question.

A sort will not work on a column that contains any merged cells, so the merged cells will need to be unmerged (which you can do by clicking the merge button on the formatting toolbar) then enter the relevant data into each of the cells.

Amanda

· How Excel Training Can Improve Your Company's Sales Process
· Fun Things I've Done With Excel
· Do You Really Need Excel VBA Training?
· How to Create Better Excel Spreadsheets: Part Four
· What's Better Than the Help Function in Excel? Microsoft Training

Excel tip:

Reset Excel toolbars to default settings

If you find any of your toolbars in Excel have changed (i.e. they are missing or have extra buttons) then you can reset them to their defaults.

1. Go to Tools - Customise.
2. Select the Toolbars tab.
3. Select (highlight) the name of the toolbar you wish to reset, then click the Reset button on the right.
4. Close the dialogue box.

View all Excel hints and tips

Institute of IT Training - Accredited Training Provider

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application

Main information pages

excel computer training london - Sort data with different size cells

Related articles

Excel tip:

Reset Excel toolbars to default settings