Hi Walter,
I'm up late, so I'll jump in. After you select all the columns and rows
you want to sort, do NOT click on column W. Instead, click on the Data
menu, then click Sort. A window should open up with two tabs on it, with
the Sort Criteria tab showing. From the first Sort By drop down list,
select Column W. Then click the Ok button and everything should be
sorted by the value in col.W.
Hope that helps,
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
[email protected] <mailto:[email protected]> /
Walter Hildebrandt wrote:
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
