Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
entering new data in a saved spreadsheet without losing formulas?
How do I do this?
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
entering new data in a saved spreadsheet without losing formulas?
Hi Jackie,
As long as you do not overwrite the formulas, then any new data will not affect the formula. I suspect though that there is more to this question. Are you concerned about writing new data into a cell that has a formula in it? The way to stop a cell's data being overwritten is to put protection onto it. This means taking protection off all the other cells otherwise you will not be able to write data to any cell. First select the whole worksheet concerned, then go to Format\Cells and select the protection tab and unselect the 'locked' tick box, then select the cells with the formula you want to protect and go back to Format\Cells\Protection and select the locked box. This now has set only those cells that you want to protect able to be protected. All the other cells will now be unprotected. To go to Tools\Protection\Protect sheet and that will provide you with options to complete. Leave the tick in the box "protect worksheet..." and assign a password that will allow the protection to be removed if and when you need to access those secured cells. Now you should be able to write to all but the cells containg the formula. Hope this is what you were after. Regards DavidC "Jackie in Houston" wrote: How do I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Inserting a new line in spreadsheet | Excel Discussion (Misc queries) | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) |