Another tedious IT question (Excel)

[mrsd]

Please can someone tell me how to organise entries on an excel sheet by number ? The first column is numbers, currently in random order and I'd like to order based on these. I have total IT numptyism where excel is concerned -spreadsheets being best left to accountants IMHO- so I hope someone can help. Thanks xx.

[plotloss]

Highlight the column in question.

Hit Range at the top

Then Sort...

Matt.

[t1grm]

plotloss said: Highlight the column in question.

Hit Range at the top

Then Sort...

Matt.

Better highlight all of the columns in question otherwise you'll just sort the data in the highlighted column and the rest of the data will be out of synch with that column. Assuming you want to sort all of it.

[Beano500]

plotloss said: Highlight the column in question.

Hit Range at the top

Then Sort...

Matt.

Except that will only sort the column that you've highlighted, I think. You should highlight either the entire sheet or the columns you want to Sort.

[mrsd]

Where might range be lurking

[Beano500]

mrsd said: Where might range be lurking

And (possibly depending on version) it's "Data" and "Sort" that are the commands.....

[plotloss]

On the sort dialogue there will be an option to keep all the rows in sync, you dont need to highlight the entire range if you only want one sort criteria.

I dont have excel in front of me at the moment, but I think it may be under format...

Matt.

[Big Al.]

Hi MrsD.
It's the sort function you need.
Go to DATA (top row)
Then SORT
A window will appear that will allow you to sort by the columns you like.
If you have a header row, check this box at the bottom and the names in the sort boxes above will change to match.


If you still get problems then come back to me on line.

Hope this makes sense and helps.

[tuscan_s]

Highlight all columns and rows involved then click Data at the top, then Sort...

It gives you some options for sorting then click OK!

[Big Al.]

plotloss said: Highlight the column in question.

Hit Range at the top

What version you using Matt, I can't find that either.

[plotloss]

I think I may have got the Range bit arse about face as I use 123 at work (GGRRRR!!) and XL at home.

Matt.

[mrsd]

Sorted it (in both senses) thanks guys. Selecting the lot then hitting the A-Z down arrow type thing did the job (< eloquent huh) Didn't realise I had to select everything first Now all I have to work out is why hitting reply got me to Castle Motorsport's page Oi. Ted. sort it out !

>> Edited by mrsd on Wednesday 26th March 14:47