Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i sort a complete work sheet in excel
When sorting a column in excel, the data in the other columns don't sort with
it. How do I sort the whole work sheet? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i sort a complete work sheet in excel
Highlight all the columns before doing the sort, then all columns will sort
with the the sort column. You can quickly highlight the whole sheet by clicking the unmarked button in the top left hand corner of the sheet. ( Between the "A" column Button and the "1" row button.) "Jerry" wrote: When sorting a column in excel, the data in the other columns don't sort with it. How do I sort the whole work sheet? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i sort a complete work sheet in excel
I never let excel guess at the range to sort.
I always select the range that I want to sort, then use Data|sort. If you don't select the whole range, you're leaving the range to sort up to excel and sometimes excel guesses incorrectly. Jerry wrote: When sorting a column in excel, the data in the other columns don't sort with it. How do I sort the whole work sheet? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter, sort, lookup from other sheet | Excel Discussion (Misc queries) | |||
In Excel, how do you make one whole sheet equal to another. | Excel Discussion (Misc queries) | |||
How do I create a watermark on an excel work sheet? | Excel Discussion (Misc queries) | |||
Can't get a formula to work in each row of an Excel sheet. | Excel Worksheet Functions | |||
Sort data from 1 work sheet into another | Excel Worksheet Functions |