Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi there,
I forgot how to leave one cell fixed while copying a formula down a column. For example, "=RC[-3]*R[-45]C[-5]" should read "=RC[-3]*R[-46]C[-5]" I recall using a Dollar sign ("$") to hardwire a cell in a formula. My formula should then read "=RC[-3]*$R9$C3" However, this doesn't seem to work. Thank you for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copying cell links with fixed number in between | Excel Worksheet Functions | |||
Removing a period and leaving maintaingn a fixed #of numbers | Excel Worksheet Functions | |||
Copying fixed cell value from different worksheets to new worksheet | Excel Discussion (Misc queries) | |||
copying info from one cell to another, changing the format, but leaving the number | Excel Worksheet Functions | |||
Can you have fixed cell reference when dragging/copying formulae? | Excel Discussion (Misc queries) |