| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i keep it like this, A1:c1/b1, A2:c2/b1, A3: c3/b1?
When i drag down the formula from Cell A1, it goes like this, cell A1:c1/b1, cell A2:c2/b2, cell A3: c3/b3, cell A4:c4/b4 and so on.. I would like the formula to be like this, cell A1:c1/b1, cell A2:c2/b1, cell A3: c3/b1, cell A4: c4/b1 .. How do i keep it constant at b1? Any form of assistance will be appreciated. Thanks in advance! Regards, Matt -- boneyzz ------------------------------------------------------------------------ boneyzz's Profile: http://www.excelforum.com/member.php...o&userid=30927 View this thread: http://www.excelforum.com/showthread...hreadid=506024 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do i keep it like this, A1:c1/b1, A2:c2/b1, A3: c3/b1?
Switch from this: A1: =C1/B1 to this: A1: =C1/B$1 Then copy that formula down. (The dollar sign in a reference "locks in" that part of the reference.) Does that help? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=506024 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do i keep it like this, A1:c1/b1, A2:c2/b1, A3: c3/b1?
goodness, that was so easy.. Thanks for the guidance guys! -- boneyzz ------------------------------------------------------------------------ boneyzz's Profile: http://www.excelforum.com/member.php...o&userid=30927 View this thread: http://www.excelforum.com/showthread...hreadid=506024 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do i keep it like this, A1:c1/b1, A2:c2/b1, A3: c3/b1?
glad it helped
-- Don Guillett SalesAid Software "boneyzz" wrote in message ... goodness, that was so easy.. Thanks for the guidance guys! -- boneyzz ------------------------------------------------------------------------ boneyzz's Profile: http://www.excelforum.com/member.php...o&userid=30927 View this thread: http://www.excelforum.com/showthread...hreadid=506024 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
