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
"DTucker" wrote:
> 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.
>
> "CLR" wrote:
>
> > 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
> >
> >
> >
> > "DTucker" wrote:
> >
> > > 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?
|
Similar Threads
