Posted 8 September 2017, 2:44 pm EST
I have a row which is "frozen" at the top of the spread and I still want to allow the user to sort the spread via the headers.
Of course this means that when the user sorts the spread, the frozen row which should always stay at the top (it's purpose is some general input), will be sorted into another place in the spread.
Is there any "special" way to achieve this, or does it mean I have to do a custom sort routine which makes sure this row always end up before the others?
Also, autosort splits spanned cells but I suppose I could always re-span then after the sort.