Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have created a spreadsheet to be used by others in which they will input
their monthly data. So many of you have helped me put this thing together--I am extremely grateful to you all. My hopefully last question is regarding protection. I have protected all of the worksheets, as the last time we did this sort of spreadsheet, novice users ended up deleting and changing all of the formulas and links. However, I realize that you cannot use the 'sort' function while the worksheet is protected. They will need to sort their data. Is there a way to protect a worksheet while also keeping the sort function? Thanks for any insight! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do i delete a row in a excel worksheet that is protected | Excel Worksheet Functions | |||
SORTING question | New Users to Excel | |||
Sorting protected worksheet | Excel Discussion (Misc queries) | |||
Sorting protected worksheets | Excel Discussion (Misc queries) | |||
How use group and ungroup functions while worksheet is protected | Excel Worksheet Functions |