Members Login
Username 
 
Password 
    Remember Me  
MomSquawk -> About Mom -> Microsoft Excel Help anyone?
Post Info TOPIC: Microsoft Excel Help anyone?
apies


Guru

Status: Offline
Posts: 7897
Date: Mar 1, 2010
Microsoft Excel Help anyone?
Permalink  
 

hey guys.

i need a project to keep my mind busy, so i'm assembling a coupon binder that i'm going to try to sell on ebay.

i'd like to include a copy of my shopping spreadsheets on CD if the buyer requests it.  here's my question - i have formulas set to calculate totals, but when i delete the cell contents, it deletes the formulas too.

does anyone have enough excel experience to know how to lock the formula in the cell even if you change the contents?  (i have googled to no avail)

thanks in advance!  :)


__________________
Sonya


Guru

Status: Offline
Posts: 10400
Date: Mar 1, 2010
Permalink  
 

let me check for you.

Did you try clearing (right click) cells not deleting them?



__________________



Sonya


Guru

Status: Offline
Posts: 10400
Date: Mar 1, 2010
Permalink  
 

wait, i'm confused.

if you delete the cells, the formulas will go away.

do you need to delete the cells?

can you just delete the contributing columns?

I'm online if you want to chat about this

__________________



crystal


Guru

Status: Offline
Posts: 1303
Date: Mar 2, 2010
Permalink  
 

you can't delete that cell.  you need to delete (or set to 0) the columns that are part of the formula. 

for example, let's say you have

Column A    Column B   Column C
1                  1              1+1=2


Instead of deleting the formula from column C, you should make Col A and Col B equal to 0.  Does that make sense?  Or am I missing something?

__________________
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.
MomSquawk -> About Mom -> Microsoft Excel Help anyone?
Post to Digg Post to Del.icio.us


Create your own FREE Forum
Report Abuse 		Powered by ActiveBoard