I have a sheet with several rankings tables on it. When the sheet is protected I am not able to sort the data. I want users to be able to sort the data without messing up the data! Is there a way around this?
I have a sheet with several rankings tables on it. When the sheet is protected I am not able to sort the data. I want users to be able to sort the data without messing up the data! Is there a way around this?
Tools > Protection > Protect Sheet, then check the Sort box.
HTH,
Jason
That does not work, i think it might be because they are tables?
I have attached a sample of what I am working with, hopefully this helps!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks