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

excel computer training london - sort data different size

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel computer training london - Sort data with different size cells

excel computer training london - Sort data with different size cells

ResolvedVersion Standard

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

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

Excel tip:

Deleting a range of cells using the autofill handle

Firstly, select the range of cells for which you would like to clear the contents. Then drag the autofill handle to the the top left corner of the selection whilst holding down the shift key. Your selected contents should then be deleted.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.13 secs.