811 votes145 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Great suggestion – thanks again for taking the time to put it on this site and for the thoughtful followup comments. This is pretty related to some other work we’ve got going and already has a fair number of votes, so we’ll work on getting plans in place now and hope to get started on this soon.
John [MS XL]Anonymous supported this idea ·
An error occurred while saving the commentAnonymous commented
I too would very much like this feature. Currently never used cells have useful properties that can be very valuable, for example the fact they always appear at the bottom of a sort. It is very frustrating that once a cell contains any formula at all it is impossible to regain those properties, even if the cell is set to "", etc.
As Roy pointed out below, it would be great to "...sort a set of data and NULLs appear at the bottom of the sort result just like never used cells would rather than as a separate grouping" above those.