Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel: How do I protect cells containing formulas?
A very simple worksheet with A2 as my usable or "entry cell". Cells B2, C2
AND D2 are the cells which compute information from the number entered in cell A2. How do I protect cells B2 - D2 and leave cell A2 open for information entry? Thanks in advance for any assistance |
#2
|
|||
|
|||
Excel: How do I protect cells containing formulas?
Milo
Protection in Excel is a two-stage process. All cells are lock by default, so select the cells you want un-locked and go to FormatCells...Protection tab and un-check locked. Now go to ToolsProtectionProtect Sheet... and all cells will be locked barring those you un-locked -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Milo" wrote in message ... A very simple worksheet with A2 as my usable or "entry cell". Cells B2, C2 AND D2 are the cells which compute information from the number entered in cell A2. How do I protect cells B2 - D2 and leave cell A2 open for information entry? Thanks in advance for any assistance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Putting Excel formatting and/or formulas into CSV file | Excel Discussion (Misc queries) | |||
Can Excel recognize when data is entered and apply formulas? | Excel Worksheet Functions | |||
Excel should let me use formulas that refer to other cells w/ form | Excel Worksheet Functions | |||
how do I get excel to ignore blank cells in formulas | Excel Worksheet Functions | |||
How do I password protect cells in a spreadsheet created in Excel | Excel Worksheet Functions |