how do i lock a sort, ie no header row

S

sotydor

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?
 
F

FSt1

hi
record a macro. Tools>macro>record 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. tools>macro>macros>select macro>run

regards
FSt1
 

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