| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting with Sheet Protection On
We are working with a worksheet that has the first two rows protected. Is it
possible to sort the columns under the first two rows with the protection on? When we highlight and try to sort, the sort option is grayed out. Thank you in advance. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sorting with Sheet Protection On
sfurney wrote:
We are working with a worksheet that has the first two rows protected. Is it possible to sort the columns under the first two rows with the protection on? When we highlight and try to sort, the sort option is grayed out. Thank you in advance. When you protect the worksheet, there is a list that says "Allow all users of this worksheet to:". Check "Sort". |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sorting with Sheet Protection On
That did it - thank you so much.
"Glenn" wrote: sfurney wrote: We are working with a worksheet that has the first two rows protected. Is it possible to sort the columns under the first two rows with the protection on? When we highlight and try to sort, the sort option is grayed out. Thank you in advance. When you protect the worksheet, there is a list that says "Allow all users of this worksheet to:". Check "Sort". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sheet protection | Excel Worksheet Functions | |||
| Sheet Protection, Allow Sorting | Excel Discussion (Misc queries) | |||
| sorting and protection | Excel Discussion (Misc queries) | |||
| Protection and sorting | Excel Worksheet Functions | |||
| Sheet Protection | Excel Discussion (Misc queries) | |||
Linear Mode
