how do i lock a sort, ie no header row
 

I want to sort by no header row, colum M, the colum N, then colum O.
I do not want to have to insert this data everytime I sort. How can I
preserve the order of this sort?

how do i lock a sort, ie no header row
 

hi
record a macro. Toolsmacrorecord new macro....
give the macro a name. do your sort. the macro will remember.
you can assign the macro to a toolbar icon, a sheet command button or select
from the menu i.e. toolsmacromacrosselect macrorun

regards
FSt1



"sotydor" wrote:

I want to sort by no header row, colum M, the colum N, then colum O.
I do not want to have to insert this data everytime I sort. How can I
preserve the order of this sort?