Joe, when I select all the cells and then click on column W, all the cells become unselected except those in column W. How do I select cells in such a way that they stay selected when I click on column W to get ready to sort?
Walter On Thu, Jul 9, 2009 at 9:25 PM, JOE Conner <[email protected]> wrote: > Walter Hildebrandt wrote: > >> A spreadsheet has data in rows A through CX. Column W is a column with >> only >> numbers. The complete spreadsheet is to be sorted by doing a Desending >> Sort on column W. When the Sort is done only column W is sorted. Is >> there >> some way to have all the columns sorted based on column W. For example if >> the Cell W1 becomes W3, all the other cells in row 1 would also move to >> row >> 3. >> > Walter, the sort acts upon a prior selection. If you want all rows to > remain intact, select all rows first. Then sort > on column W. > > Joe Conner, Poulsbo, WA USA > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] >
