|
| 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
|
|
|
|
|
|
|
|
|
|