Regina, It was a great help. thank you
Vince On Sep 23, 2013, at 4:09 PM, Regina Henschel wrote: > Hi Vincent, > > Vincent Juliano schrieb: >> In using a spreadsheet , using two columns where the first column >> contains the part description and the second column indicates where >> the part is to be found alphabetizaation was tried.. >> >> This feature hasn't been used in quite some time. When activated the >> alphabetizing is done using the SECOND column. This puts all the >> part descriptions in chaos but the placement in alphabetical order. > > Then you have only sort the second column and not the whole data range. > >> >> To accomplish the alphabetization properly the parts list was cut and >> placed in the second column behind the position the part is to be >> found. >> >> It works and then the columns are then changed into proper placement >> and all is well. >> >> It's necessary to upgrade the spreadsheet because of constant >> additions and removals. >> >> What is the necessary procedure to get the alphabetization of the >> spreadsheet based on the first column? > > "first column"? > > For to get sorting based on the second column, and for to be able to insert > and delete records, do this: > > Mark the whole data range including column labels (=field headers) and an > additional empty row at the end of the date. The empty row is needed, because > you can only insert a row above the current row, not after the current row. > Name this data range via menu Data > Define Range. Click the "More" button > and check the options "Contains column labels" and "Insert or delete cells". > The later provides, that the address of this data range is adapted > automatically, so that you always get the correct range, when you use its > name. > > If the data range is no longer selected, select it via menu Data > Select > Range. Then use menu Data > Sort. In that dialog choose the label of the > second column. Then set the other needed sorting options in that dialog. > > After you have insert a record (=row) in the data range, set cursor into the > data range and use menu Data > Refresh Range. Now your data range is sorted > again with the same initial settings. > > Kind regards > Regina > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
