Hi Excel Gurus,
Does anyone know what setting should I use in order to allow a user to sort data in a table when some of the cells are locked?
When I protected the sheet I ticked the option to allow user to sort data but it doesnt work...
Any help as usual would be greatly appreciated...
Cheers
Does anyone know what setting should I use in order to allow a user to sort data in a table when some of the cells are locked?
When I protected the sheet I ticked the option to allow user to sort data but it doesnt work...
Any help as usual would be greatly appreciated...
Cheers