formula

while entering the formula in worksheet, there is a
specific value in one cell and i want to keep the same
cell address in every formula. So when i copy the formula
to next cell, normally the cell address also change and i
want the same address cell, put in previous formula.
please guide me.
regards
ram

sounds like you need to use an absolute reference - prefix
the cell reference with $, e.g.

$A$1

-----Original Message-----
while entering the formula in worksheet, there is a
specific value in one cell and i want to keep the same
cell address in every formula. So when i copy the formula
to next cell, normally the cell address also change and
i
want the same address cell, put in previous formula.
please guide me.
regards
ram


.

Hi

Use $ sign..i.e. for =A1 use =$A$1

if u use =$a1 then only column will freeze
if u use =A$1 then only column will freeze

Regards
Asim



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/