| View previous topic :: View next topic |
| Author |
Message |
jml3310
General User
Joined: 08 Oct 2007
Posts: 26
|
 Posted: Tue Oct 09, 2007 3:01 am Post subject: Sorting protected sheets |
 |
|
I have certain columns,but not all columns, in a spreadsheet that I don't want to allow modification. I have protected those columns and have protected the sheet, but am not able to sort the data in the sheet.
Is it possible to protect certain columns and still allow sorting? |
|
| Back to top |
|
 |
huwg
Super User
Joined: 14 Feb 2007
Posts: 890
|
| Posted: Wed Oct 10, 2007 12:26 am Post subject: |
|
|
| I've never found a way. It would be handy, and so would filtering of protected cells. |
|
| Back to top |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Wed Oct 10, 2007 5:27 am Post subject: Re: Sorting protected sheets |
|
|
Sorting is a form of modification. If sorting was allowed, the user could sort on a column other than the one you choose. It seems you can't have your cake and eat it.
David. |
|
| Back to top |
|
|
B Marcelly
Super User
Joined: 12 May 2004
Posts: 1414
Location: France
|
| Posted: Wed Oct 10, 2007 8:06 am Post subject: |
|
|
Hi,
You may copy the zone of cells you are interested in, then go to another (empty) sheet and Paste special. It allows you to paste numbers instead of formulas.
Now you can sort the result as you want.
______
Bernard |
|
| Back to top |
|
|
|
