I want to s ort a range, When I go to Data, the options are greyed o ut. How can I get them to operate?
Most likely the range to be sorted contains array or matrix formulas that can’t be sorted. Or you have Track Changes active in which sorting is disabled (to deactivate menu Edit → Track Changes → Record). If both is not the case then provide more details.
1 Like
Why is sort disabled when Tracking Changes is active?
Because it would result in a mass of cell content changes in the tracking, plus all changes of formulas referencing those cells that are adapted, and being able to reject those individually wouldn’t make sense either.
1 Like