How do I repeat an item in multiple formulas w/out retyping each

F

Felicity

Several formulas across a row in each cell with the same base item. Is it
possible to auto fill item without having to type it over and over again to
add it to the formulas?
 
L

lk

Have you tried to use the "$"? $A$1 is an absolute reference to cell A1, but
you can also use $A1 and A$1 which can be copied across rows/columns. The
trick to using $A1 and A$1 is to "lock" the row/column that doesn't change
with the $. You can type the $ or press the F4 key. If you keep pressing
F4, excel will scroll through your options.
 
Top