Help with Spreadsheet Please

I don't think you've explained yourself very well. Can you try again?

What precisely are you trying to do?

I'm trying to sort rows into ascending order on a M.S Works spreadsheet using tools.
Columns I can do, but rows I need some help with, if indeed it is possible!!

Thank you.

Are you from Kent or Kentish Town?

As for the question, sorry I don't know the answer - I use spreadsheets too, but I do everything manually when when needing to sort rows or columns into ascending order

Good luck.

Thanks for the response Darren.

No, not Kentish Town although my dad was born not far from there.

Kentish Men are born West of Medway whilst Men of Kent are born East of the River.

Thanks again and good luck.

KM, in excel this can be done by sorting in a column, copying, then select 'Paste Special' and 'Transpose'.. I think this is what you are after..

so it would turn

5
4
3
2
1

into

5   4   3   2   1

Yo.
Many thanks indeed.

I have used Excel 2000 before for scoring my club annual Bridge Scores to find a yearly winner ( Ten Highest Scores ) it worked very well but do not now have access to Excel, hence my trial with a Works spreadsheet.
As I have to List Players down Col. A and have their weekly scores in Rows 1 to 30, or so, below dates, I think I shall have to find another source of Excel to work with.

But thank you again and I shall battle on!!

"I think I shall have to find another source of Excel to work with."


Are you aware of.........


http://www.openoffice.org/

?

If you highlight the row you want to sort into order, as you would if sorting by a column.

Then goto data, sort.

Than click on Options

Then click on sort left to right

This should then do the trick for you

Hope this helps............