damian_r_Home
Board Regular
- Joined
- Jan 8, 2005
- Messages
- 231
- Office Version
- 365
- 2007
- Platform
- Windows
Howdo.
We have a common spreadsheet in the office which has numerous columns with filters on it.
The problem is that somebody (and i cant find who) keeps adding a SORT ability to one of the columns and whatever i do to try and remove the SORT function the spreadsheet remains as it was when SORTed rather than going back to the original way it was all listed
I'm getting the horrible feeling that once sorted it may not even be possible to put them back to how they were listed and that |I might have to manually put some 450+ rows back to their original order manually - if this is the case, how can I stop people from using this sort function?
As usual, any help will be gratefully accepted.
Stay safe
D
We have a common spreadsheet in the office which has numerous columns with filters on it.
The problem is that somebody (and i cant find who) keeps adding a SORT ability to one of the columns and whatever i do to try and remove the SORT function the spreadsheet remains as it was when SORTed rather than going back to the original way it was all listed
I'm getting the horrible feeling that once sorted it may not even be possible to put them back to how they were listed and that |I might have to manually put some 450+ rows back to their original order manually - if this is the case, how can I stop people from using this sort function?
As usual, any help will be gratefully accepted.
Stay safe
D