If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
formula
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 . |
#3
|
|||
|
|||
formula
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/ |
Thread Tools | |
Display Modes | |
|
|