General Betting
There is currently 1 person viewing this thread.
Excel is fine with obtaining left to right increasing cell values via tools etc. Microsoft Works Spreadsheet, however seems ok with columns but rows.
Grateful for any help, thank you.
Grateful for any help, thank you.
sort by:
Show
per page
Replies: 9
|
By:
I don't think you've explained yourself very well. Can you try again?
What precisely are you trying to do? |
|
By:
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. |
|
By:
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. |
|
By:
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. |
|
By:
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..
|
|
By:
so it would turn
5 4 3 2 1 into 5 4 3 2 1 |
|
By:
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!! |
|
By:
"I think I shall have to find another source of Excel to work with."
Are you aware of......... http://www.openoffice.org/ ? |
|
By:
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............ |