New Posts For Thread: Help with Spreadsheet Pleasehttps://community.betfair.com/general_betting/go/thread/view/94082/28236573/help-with-spreadsheet-pleaseExcel 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.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 OptionsThen click on sort left to rightThis should then do the trick for youHope this helps............https://community.betfair.com/general_betting/go/thread/view/94082/28236573/help-with-spreadsheet-please?post_id=506082889#506082889If 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 OptionsThen click on sort left to rightThis should then do the trick for youHope this helps............Thu, 01 Sep 2011 04:44:37 -0500"I think I shall have to find another source of Excel to work with."Are you aware of.........http://www.openoffice.org/?https://community.betfair.com/general_betting/go/thread/view/94082/28236573/help-with-spreadsheet-please?post_id=505978311#505978311"I think I shall have to find another source of Excel to work with."Are you aware of.........http://www.openoffice.org/?Mon, 29 Aug 2011 22:36:23 -0500Yo.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 tohttps://community.betfair.com/general_betting/go/thread/view/94082/28236573/help-with-spreadsheet-please?post_id=505958033#505958033Yo.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 toMon, 29 Aug 2011 13:32:00 -0500so it would turn54321into 5 4 3 2 1https://community.betfair.com/general_betting/go/thread/view/94082/28236573/help-with-spreadsheet-please?post_id=505947625#505947625so it would turn54321into 5 4 3 2 1Mon, 29 Aug 2011 09:39:14 -0500KM, 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..https://community.betfair.com/general_betting/go/thread/view/94082/28236573/help-with-spreadsheet-please?post_id=505947589#505947589KM, 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..Mon, 29 Aug 2011 09:37:52 -0500Thanks 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.https://community.betfair.com/general_betting/go/thread/view/94082/28236573/help-with-spreadsheet-please?post_id=505947205#505947205Thanks 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.Mon, 29 Aug 2011 09:26:18 -0500Are 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 orderGood luck.https://community.betfair.com/general_betting/go/thread/view/94082/28236573/help-with-spreadsheet-please?post_id=505946805#505946805Are 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 orderGood luck.Mon, 29 Aug 2011 09:13:40 -0500I'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.https://community.betfair.com/general_betting/go/thread/view/94082/28236573/help-with-spreadsheet-please?post_id=505941697#505941697I'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.Mon, 29 Aug 2011 06:26:13 -0500I don't think you've explained yourself very well. Can you try again?What precisely are you trying to do?https://community.betfair.com/general_betting/go/thread/view/94082/28236573/help-with-spreadsheet-please?post_id=505938619#505938619I don't think you've explained yourself very well. Can you try again?What precisely are you trying to do?Mon, 29 Aug 2011 04:22:03 -0500Excel 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.https://community.betfair.com/general_betting/go/thread/view/94082/28236573/help-with-spreadsheet-please?post_id=505937675#505937675Excel 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.Mon, 29 Aug 2011 03:29:33 -0500