#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Lock cell

how can i lock only one cell in my worskeet???
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Lock cell

Select all the cells
format|cells|protection tab|check unlocked
select just the single cell you want locked
format|cells|protection tab|check locked

And for that locked cell to be treated as locked, you'll need to protect the
worksheet:
tools|protection|protect sheet

(be aware that worksheet protection is easily broken--don't rely on this to
protect your intellectual property.)

teddi wrote:

how can i lock only one cell in my worskeet???


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default Lock cell

Select the whole sheet.
Format/ Cells/ Protection/ remove the tick mark from Locked.

Select the cell you want to lock, same process but tick Locked.

Tools/ Protection/ protect the worksheet.
--
David Biddulph

"teddi" wrote in message
...
how can i lock only one cell in my worskeet???



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
How to lock a cell Skjetve Excel Worksheet Functions 2 June 22nd 07 06:40 AM
I have lock a wookbook but one cell does not want to lock it Mimi Excel Discussion (Misc queries) 2 January 21st 07 10:59 PM
I have lock a wookbook but one cell does not want to lock it Mimi Excel Discussion (Misc queries) 1 January 21st 07 09:44 AM
Lock data in a cell a specific cell based on selection on other ce CrimsonPlague29 Excel Worksheet Functions 0 May 10th 06 11:06 AM
Cell Lock Josh Excel Worksheet Functions 3 December 17th 04 07:13 PM


All times are GMT +1. The time now is 05:48 AM.

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"