Groups > WordPerfect Office > QuattroPro X3 > Re: Sorting a sheet by one column




Sorting a sheet by one column

Sorting a sheet by one column
Mon, 31 Mar 2008 11:27:46 -070
When I select a column in a sheet to sort all of the rows together, by 
ascending order of the numbers in the 3rd column, I only get the selected 
cells in the selected column to sort leaving all the other columns as they 
were to begin with.This messes up all of the row data such that only one 
column in the sheet has changed.

Many thanks for any help and suggestions.
Could not find anything in the Help or on Corel.com 


Post Reply
Re: Sorting a sheet by one column
Mon, 31 Mar 2008 13:38:34 -050
John R. Sennett wrote:
> When I select a column in a sheet to sort all of the rows together, by 
> ascending order of the numbers in the 3rd column, I only get the selected 
> cells in the selected column to sort leaving all the other columns as they

> were to begin with.This messes up all of the row data such that only one 
> column in the sheet has changed.
> 
> Many thanks for any help and suggestions.
> Could not find anything in the Help or on Corel.com 

Select all the data you want sorted.  Then when you click Tools > 
Sort.... you will get a dialog.  Put the column you want to sort by in 
the box marked '1st'   (column C in your case)
Post Reply
Re: Sorting a sheet by one column
Mon, 31 Mar 2008 19:32:37 GMT
John:
> When I select a column in a sheet to sort all of the rows together, by 
> ascending order of the numbers in the 3rd column, I only get the selected 
> cells in the selected column to sort leaving all the other columns as they

> were to begin with.This messes up all of the row data such that only one 
> column in the sheet has changed.
>
You need to select as many of the rows as appropriate in all the columns you 
wish to be sorted..
QP is just doing what you told it to.
In the Sort Dialog, see that the "1st" Col is the one you wish to use
as the 
key.
-- 
Good wishes!
Roy Lewis
C_Tech volunteer
(UK)

Post Reply
about | contact