| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need to lock pivot table header row height | Excel Discussion (Misc queries) | |||
| How to lock calculated data before a sort? | Excel Discussion (Misc queries) | |||
| sort, 2 row header | Excel Worksheet Functions | |||
| how can I sort with header not on row 1 | Excel Discussion (Misc queries) | |||
| SORT Header Row(s) | Excel Discussion (Misc queries) | |||
Linear Mode
