LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 30th 06, 04:47 PM posted to microsoft.public.excel.newusers
Jackie in Houston
Posts: n/a
Default entering new data in a saved spreadsheet without losing formulas?

How do I do this?

  #2   Report Post  
Old January 31st 06, 01:00 AM posted to microsoft.public.excel.newusers
Posts: n/a
Default 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.



"Jackie in Houston" wrote:

How do I do this?

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
Inserting a new line when external data changes Rental Man Excel Discussion (Misc queries) 0 January 11th 06 07:05 PM
Inserting a new line in spreadsheet Rental Man Excel Discussion (Misc queries) 2 January 9th 06 04:55 PM
From several workbooks onto one excel worksheet steve Excel Discussion (Misc queries) 6 December 1st 05 08:03 AM
Printing data validation scenarios SJC Excel Worksheet Functions 14 July 24th 05 12:43 AM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM

All times are GMT +1. The time now is 01:51 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017