View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
DaNoArt DaNoArt is offline
external usenet poster
 
Posts: 2
Default I need to protect individual cells in Excel like Supercalc did

To all 3 replies. Thanks for the instruction. I will try this today. Hope
it works. But it sure was easier in SuperCalc. All you did was select the
cell/s, then click "protect". That was it.
This is like traveling from Houston to L.A. by way of NY. <g
PS: to add to the sheet each week now, do I have to unprotect the file each
time then protect again?
"ed" wrote:

In the cells you want protected go to the Format Menu and
Format/Cells/Protect and/or Hidden You can mark as many cells as you
want in one operaation. Then protect the worksheet. Only the
cells you formatted will be Hidden/Protected.

ed

cells in my Excel spreadsheet. The old SuperCalc
allowed me to protect my formulas so i could not accidentally overwrite or
delete them.

I've tried many times to figure it out. it only allows me to protect a
whole file. this is usless to me.

Please change this feature or let me know how.
Thanks.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc