Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How attach data in a row so it can be sorted by the date column?
I have a four spread sheets all the same that I have copied and pasted into
one. I need to know now how to sort the rows by the date column. When I select the date column and hit the tool bar a-z button only the dates sort and not other information in the adjacent columns. What can I do? |
#2
|
|||
|
|||
Hi!
Select the entire range that you want to sort. Goto DataSort. Sort by the column that contain the dates. Biff -----Original Message----- I have a four spread sheets all the same that I have copied and pasted into one. I need to know now how to sort the rows by the date column. When I select the date column and hit the tool bar a-z button only the dates sort and not other information in the adjacent columns. What can I do? . |
#3
|
|||
|
|||
Select the *entire* range that you wish to be included in the sort
operation. Then start the sort. Never, never, never allow XL to choose your range. It's right most of the time ... BUT ... *not all* of the time! -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Steve Horn" <Steve wrote in message ... I have a four spread sheets all the same that I have copied and pasted into one. I need to know now how to sort the rows by the date column. When I select the date column and hit the tool bar a-z button only the dates sort and not other information in the adjacent columns. What can I do? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |