Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I want a cell like "Name" be locked, but the cell next to it to be open for
entering a name. How do I do it? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Cell formats have a "locked" property that is actually locked by
default. If you protect a sheet it will engage all of the locks, so choose which ones you wish to unlock first (with Format/Cells/ Protection - version dependent!), and then protect the sheet. On Sep 3, 12:25*pm, Tag1948 wrote: I want a cell like "Name" be locked, but the cell next to it to be open for entering a name. How do I do it? |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Tag1948 wrote:
I want a cell like "Name" be locked, but the cell next to it to be open for entering a name. How do I do it? Open Excel. Hit F1 (or select Help / Microsoft Excel Help). In the box under "Assistance" that says "Search for:" type "protect cells". Hit enter. Or, click here... http://office.microsoft.com/en-us/ex...548251033.aspx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protect only certain Cells? | Excel Discussion (Misc queries) | |||
How do I protect certain cells? | Excel Discussion (Misc queries) | |||
Protect cells | Excel Discussion (Misc queries) | |||
Protect Cells | New Users to Excel | |||
protect cells in csv | Excel Worksheet Functions |