View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default What do I use to reference the same cell in multiple formulas

Reference it in absolute terms: $D$3
that way it won't change as you fill/copy the formula to other cells.

You may also want to look into using Named Ranges - see Excel Help on the
topic. That allows you to give a name to a cell and use that name in
formulas without having to worry where the cell is. Lets say that your
formula contains the sales tax rate in your area. You could name cell D3
SalesTax and then in your formula you could use SalesTax instead of $D$3.

"Tammy" wrote:

I am trying to set up a formula where I will need to use for expample D3 in
all formulas, is there a way I can keep that in each formula without having
to enter it each time when I copy the formulas?

Thanks