sorting coloums

R

rau58

how can i sort one coloum of hilighted cells and information to the left and right

how can i sort one coloum of hilighted cells without affecting cells to the left and right
 
G

Gord Dibben

rau

See in-line.........

how can i sort one coloum of hilighted cells and information to the left and right.
Click to expand...

Select all columns you wish to sort together before Data>Sort.
how can i sort one coloum of hilighted cells without affecting cells to the left and right
Click to expand...

Select the one column and when Excel offers to expand the range, say NO and
stay with the single selection. This can seriously screw up data if you
neglect to undo before saving.

Gord Dibben Excel MVP
 
R

rau58

here's my delim

i have three rows of coloum indentitys above the coloum('s) to be sorte

when i sort, the three row drop to the bottom of the pag

if i state that i have a header

the top row stays and rows 2 and 3 drop
 
Top