changing formula for whole column

G

grodsmith

hi all
new excel user here - please help
want to change recurring division value (tax rate has changed!) in
expense spreadsheet
do I have to go into each cell separately and change the value? is
there a quicker way?
thanks
 
J

jpdphd

If you are lucky enough so that each occurance of the rate looks the
same and cannot be mistaken for something else, then Edit > Replace...
will work.

Specifically, if you have

/3.25

each time you do a relevant calculation, then replace /3.25 by
/3.75 or whatever. But, if /3.25 appears in some irrelevant
calculation, then you have to do it one-by-one to make sure you don't
screw up.

HOWEVER, you can do yourself a huuuge favor by putting the rate into a
cell (a cell in some conspicuous place), giving the cell a name ("rate"
might be a good choice - type it into the name box - where you normally
see the cell reference (eg A10) - press return & you've done the
naming) and then replacing /3.25 by /rate

Now when the rate changes next year, all you have to do is type the new
rate into the cell (the one whose name is "rate") and abracadabra -
it's all fixed.

jpdphd
 
Top