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/courses/london · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

2 posts

ReplyTue 17 Apr 2007, 17:22Delegate Marjolein said...

Marjolein has attended:
Excel Introduction course
Upgrade to Office 2007 course
Excel Intermediate course

Sort data with different size cells

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 VBA Intro Intermediate 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Thu 18 + Fri 19 Mar 2010	Southwark	0	FULL
2003	Mon 22 + Tue 23 Mar 2010	Bloomsbury	1		£495	£495
2007	Tue 6 + Wed 7 Apr 2010	Bloomsbury	4		£470	£475
2003	Wed 7 + Thu 8 Apr 2010	Southwark	7		£445	£450
2007	Thu 15 + Fri 16 Apr 2010	Bloomsbury	0	FULL
2003	Wed 21 + Thu 22 Apr 2010	Bloomsbury	7		£445	£450
Full Schedule: See all 36 Excel VBA Intro Intermediate course dates. Bookings currently available until 22nd December 2010.

2,024 posts

ReplyWed 18 Apr 2007, 11:19Trainer Amanda said...

RE: Sort data with different size cells

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

· Microsoft Excel can ensure you keep on top of your finances
· Utilise the web's information banks with Microsoft Excel
· Excel: From The Basic To The Advanced
· Using Dates Within Excel
· Simple Ways To Customise Excel

Excel tip:

Editing a formula quickly

If you want to edit a fomrula or text quickly witin a cell instead of the formula bar, you can click either double click in the cell or press the F2 key

View all Excel hints and tips