I have a file with 500 row, 7+ columns of data. At some point last year, I
must have sorted it without highlighting the last column. Consequently, it
is all discombobulated.

In future, I will sort it by highting the rows rather than all the cells.

However, I am wondering if there is some way to 'lock in' a sort so that
every time I sort it, all the columns are automatically included (ie - is
there a way to remove stupid human error)?


--
Joe

The best way to do this would be to create your own macro and then attach it
to a button that initiates the sort.
Simply record how you want to do a sort, add a command button and then
attach the button to your macro.

If you need more help come back

J


"jdb" wrote:


I have a file with 500 row, 7+ columns of data. At some point last year, I
must have sorted it without highlighting the last column. Consequently, it
is all discombobulated.

In future, I will sort it by highting the rows rather than all the cells.

However, I am wondering if there is some way to 'lock in' a sort so that
every time I sort it, all the columns are automatically included (ie - is
there a way to remove stupid human error)?


--
Joe