Copied 4 columns from excel doc. and pasted into another excel doc

[Guest]

I copied 4 columns from 1 excel doc. and pasted into another excel doc. The
columns are: Bates No., Date, Summary & Box No. The excel document I'm
working in have the exact same columns. I was trying to have one excel file
to work in. When I went to sort the Box column, I noticed it did not sort
the entire table. The portion of the text I copied and pasted at the bottom
of the excel doc. did not sort. Its treating the text as though it is not
part of the document. How do I fix this?

 

[Guest]

Excel starts at the cell the cursor is in and sorts all contiguious
data.....that is, until it finds an empty row or an empty column...then it
stops. It will not jump over the empty row or column and continue on the
other side..........if you want that area sorted with the other, then you
must first highlight the entire area of data you wish sorted before issuing
the sort command.......

hth
Vaya con Dios,
Chuck, CABGx3

 

[Guest]

As you can probably tell, I'm new to excel. I realized I cannot highlight
the column and click sort. So everytime I need to sort I must highlight the
entire area and then click sort and tell excel which column to sort by. I
cannot just click in the column I want sorted (without highlighting) and
click sort.

 

[Guest]

You can sort a field by just selecting a cell within the field and clicking
the ascending or decending button on the toolbar.....but this still only
sorts that data which is contiguious.....any empty columns or rows and it
won't "jump over"

Vaya con Dios,
Chuck, CABGx3