|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 3rd, 2008, 05:25 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protect cells
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
September 3rd, 2008, 05:31 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Protect cells
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
September 3rd, 2008, 05:36 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Protect cells
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
