LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I protect only the highlighted cells in Excel? John White Excel Discussion (Misc queries) 1 December 7th 05 06:57 PM
checking that cells have a value before the workbook will close kcdonaldson Excel Worksheet Functions 8 December 5th 05 04:57 PM
Cells User Select Locked after upgrade to Excel 2002 TWilson Excel Discussion (Misc queries) 1 August 5th 05 12:22 PM
How do I protect specific cells from changes in Excel? LarryH Excel Discussion (Misc queries) 2 January 25th 05 10:10 PM
how do you create drop down menus for individual cells in excel? Frosty1 Excel Worksheet Functions 2 November 15th 04 11:02 PM


All times are GMT +1. The time now is 08:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"