software

cell number does not increase when copied -
=$F$62 when copied down one row stays =$F$62 not =$F$63
how do I get the cell number to increase like other formulas doThat is because you made the column and row absolute ($), remove the $ sign
from the row reference:

=$F62

HTH
JG
quot;charliequot; wrote:

gt; cell number does not increase when copied -
gt; =$F$62 when copied down one row stays =$F$62 not =$F$63
gt; how do I get the cell number to increase like other formulas do
gt;

Hi,

Get rid of the quot;$quot; sign in front of the quot;62quot; in the formula (i.e., $F62 and
not $F$62)

Regards,
B. R. Ramachandranquot;charliequot; wrote:

gt; cell number does not increase when copied -
gt; =$F$62 when copied down one row stays =$F$62 not =$F$63
gt; how do I get the cell number to increase like other formulas do
gt;

Thanks for your help

quot;pinmasterquot; wrote:

gt; That is because you made the column and row absolute ($), remove the $ sign
gt; from the row reference:
gt;
gt; =$F62
gt;
gt; HTH
gt; JG
gt;
gt;
gt;
gt; quot;charliequot; wrote:
gt;
gt; gt; cell number does not increase when copied -
gt; gt; =$F$62 when copied down one row stays =$F$62 not =$F$63
gt; gt; how do I get the cell number to increase like other formulas do
gt; gt;

Thanks for the help

quot;B. R.Ramachandranquot; wrote:

gt; Hi,
gt;
gt; Get rid of the quot;$quot; sign in front of the quot;62quot; in the formula (i.e., $F62 and
gt; not $F$62)
gt;
gt; Regards,
gt; B. R. Ramachandran
gt;
gt;
gt; quot;charliequot; wrote:
gt;
gt; gt; cell number does not increase when copied -
gt; gt; =$F$62 when copied down one row stays =$F$62 not =$F$63
gt; gt; how do I get the cell number to increase like other formulas do
gt; gt;