how do i sort a complete worksheet by sorting columns

M

Martyn

I'm trying to sort a worksheet by columns but keep all the data on the rows
in the correct place. e.g. sort a work sheet by a date column and get it to
move all the information on each row aswell.
 
D

David Biddulph

Martyn said:
I'm trying to sort a worksheet by columns but keep all the data on the
rows
in the correct place. e.g. sort a work sheet by a date column and get it
to
move all the information on each row aswell.

Make sure you select the entire range (all the columns you're working with)
before you do your sort.
 
G

Gord Dibben

Automatic means VBA.

Excel doesn't know when/how to sort things unless you give a command, either by
Data>Sort or by VBA.


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top