How do I sort a Spreadsheet? in Excel Charts    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              Garrette 11/7/2007 7:53 AM PST   Question   I have a simple spreadsheet with multiple rows and columns. Columns contain: Date, Text, and numbers. The information in the rows must be the same after sorting. How do I sort the spreadsheet by the column(s): dates, text, and/or numbers and insure that the original information in the rows stays the same?     Was this post helpful to you?         Reply |   Top           David Biddulph 11/7/2007 8:43 AM PST   Answer   Select the whole range before you invoke the sort. Don't leave Excel to guess which rows & columns you wish to use. -- David Biddulph "Garrette" <Garrette@discussions.microsoft.com> wrote in message news:9805D749-7906-4273-B609-8403AC75C73E@microsoft.com... >I have a simple spreadsheet with multiple rows and columns. Columns >contain: > Date, Text, and numbers. > > The information in the rows must be the same after sorting. > > How do I sort the spreadsheet by the column(s): dates, text, and/or > numbers > and insure that the original information in the rows stays the same?     Was this post helpful to you?         Reply |   Top           EMMET 7/23/2008 7:01 AM PST   "David Biddulph" wrote: > Select the whole range before you invoke the sort. Don't leave Excel to > guess which rows & columns you wish to use. > -- > David Biddulph > > "Garrette" <Garrette@discussions.microsoft.com> wrote in message > news:9805D749-7906-4273-B609-8403AC75C73E@microsoft.com... > >I have a simple spreadsheet with multiple rows and columns. Columns > >contain: > > Date, Text, and numbers. > > > > The information in the rows must be the same after sorting. > > > > How do I sort the spreadsheet by the column(s): dates, text, and/or > > numbers > > and insure that the original information in the rows stays the same? > > >     Was this post helpful to you?         Reply |   Top           Carol 6/22/2009 6:53 AM PST   I too have a simple spread sheet, not generated by myself though. I did highlight the cells that I wanted to alphabetize, all but one did so? What is the problem? -- Carol :) "Garrette" wrote: > I have a simple spreadsheet with multiple rows and columns. Columns contain: > Date, Text, and numbers. > > The information in the rows must be the same after sorting. > > How do I sort the spreadsheet by the column(s): dates, text, and/or numbers > and insure that the original information in the rows stays the same?     Was this post helpful to you?         Reply |   Top           Bernard Liengme 6/22/2009 8:05 AM PST   Sort can use the first row as labels or as data. When you open the sort dialog there is a box to check indicating what you want. Let us know if this helps best wishes. -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Carol" <Carol@discussions.microsoft.com> wrote in message news:82B3CE9A-8E05-4ABE-BE4A-CCE07CE738CA@microsoft.com... > I too have a simple spread sheet, not generated by myself though. I did > highlight the cells that I wanted to alphabetize, all but one did so? > What > is the problem? > -- > Carol :) > > > "Garrette" wrote: > >> I have a simple spreadsheet with multiple rows and columns. Columns >> contain: >> Date, Text, and numbers. >> >> The information in the rows must be the same after sorting. >> >> How do I sort the spreadsheet by the column(s): dates, text, and/or >> numbers >> and insure that the original information in the rows stays the same?     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies