how do i sort a complete worksheet by sorting columns

[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.

[David Biddulph]

"Martyn" <[email protected]> wrote in message
news:[email protected]...
> 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

[Martyn]

Thanks David, worked it while waiting for a reply.

"David Biddulph" wrote:

> "Martyn" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>