| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to password protect a cell but still be able to sort ?
I am password protecting a range of cells in Excel 2000. When I do that, I
am not able to Sort the worksheet nor am I able to insert new rows or columns. Am I doing something wrong or is that by design? |
|
#2
|
|||
|
|||
|
AFAIK you'll have to unprotect the sheet, sort it, then protect it again.
Carole O "GW Trainer" wrote: I am password protecting a range of cells in Excel 2000. When I do that, I am not able to Sort the worksheet nor am I able to insert new rows or columns. Am I doing something wrong or is that by design? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect Cell Formatting | Excel Worksheet Functions | |||
| Password Protect Worksheets | Excel Worksheet Functions | |||
| Auto Protect workbook with password upon opening | Excel Worksheet Functions | |||
| protect cell | Excel Worksheet Functions | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Linear Mode
