At 21:19 09/07/2009 -0600, 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 Descending 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.
At 23:26 09/07/2009 -0700, Peter Dow wrote:
After you select all the columns and rows you want to sort, ...
One trick that hasn't been mentioned is that you often don't need to select exactly the rows and columns which you need sorted. If you select any *single* cell within the range you require, Calc will make an intelligent expansion of the selection to the range you probably require. You can see and check the expanded selection as you do the sort.
Indeed, if - in your case - you select just a single cell in column W and then go to Data | Sort..., you should find not only that the range has been correctly selected for you but also that "Column W" has already been suggested under "Sort by" in the Sort window.
I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
