how do i sort a complete worksheet by sorting columns

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.

"Martyn" <Martyn@discussions.microsoft.com> wrote in message
news:8AAC9E1F-A621-4E62-ADDE-CA9006357FEC@microsoft.com...
> 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.
--
David Biddulph

Thanks David, worked it while waiting for a reply.

"David Biddulph" wrote:

> "Martyn" <Martyn@discussions.microsoft.com> wrote in message
> news:8AAC9E1F-A621-4E62-ADDE-CA9006357FEC@microsoft.com...
> > 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.
> --
> David Biddulph
>
>
>