Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luis Moreno
 
Posts: n/a
Default how protec cell in excel?

I can´t protec cell in excel only there are options for protec sheet or work
book but there isn´'t to protec cell
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default how protec cell in excel?

Select the cells you want locked.
Format|cells|protection Tab|check Locked.

And select the cells you want unlocked
format|cells|protection tab|uncheck locked

Then tools|protection|protect sheet

Locked/unlocked cells won't mean much until the worksheet is protected.

And on top of that worksheet protection is easily broken. Don't try to protect
info that you don't want getting out. Excel doesn't have that kind of security.

Luis Moreno wrote:

I can´t protec cell in excel only there are options for protec sheet or work
book but there isn´'t to protec cell


--

Dave Peterson
Reply
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
missing cell borders in Excel Nak Excel Discussion (Misc queries) 8 April 22nd 23 06:11 AM
resetting last cell jagdish.eashwar Excel Discussion (Misc queries) 11 March 31st 06 02:06 AM
need excel to look for the 4th digit in a cell then insert new num Stefi Excel Discussion (Misc queries) 0 March 20th 06 02:45 PM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
Paste rows of numbers from Word into single Excel cell BecG Excel Discussion (Misc queries) 1 December 8th 04 04:55 PM


All times are GMT +1. The time now is 03:40 PM.

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

About Us

"It's about Microsoft Excel"