Home |
Search |
Today's Posts |
#1
|
|||
|
|||
fix cell references
I often have to fix and then unfix cell references using the $ sign to fix
and then find and replace to unfix. Is there a menu option to fix column / fix row / fix reference (and unfix). If there is I cant find it. |
#2
|
|||
|
|||
Hi AK
not AFAIK, however F4 is the shortcut key for this and takes you through a cycle of A1 - column & row relative $A$1 - column & row absolute A$1 - column relative & row absolute $A1 - column absolute & row relative would using a mixed absolute / relative reference solve your problem? Cheers JulieD "AK" wrote in message ... I often have to fix and then unfix cell references using the $ sign to fix and then find and replace to unfix. Is there a menu option to fix column / fix row / fix reference (and unfix). If there is I cant find it. |
#3
|
|||
|
|||
Thanks JulieD Unfortunately F4 does something quite different for me (not sure what yet). I do use mixed references. An example where it causes a problem is when calculated a column percent with a fixed reference to a row - and then copying the table to a new row. "JulieD" wrote: Hi AK not AFAIK, however F4 is the shortcut key for this and takes you through a cycle of A1 - column & row relative $A$1 - column & row absolute A$1 - column relative & row absolute $A1 - column absolute & row relative would using a mixed absolute / relative reference solve your problem? Cheers JulieD "AK" wrote in message ... I often have to fix and then unfix cell references using the $ sign to fix and then find and replace to unfix. Is there a menu option to fix column / fix row / fix reference (and unfix). If there is I cant find it. |
#4
|
|||
|
|||
AK
You must highlight the cell references in the formula bar before cycling through with F4. F2 or click in the formula bar to get into edit mode, then with the mouse, select the cell refs and F4. Gord Dibben Excel MVP On Wed, 16 Mar 2005 05:35:01 -0800, "AK" wrote: Thanks JulieD Unfortunately F4 does something quite different for me (not sure what yet). I do use mixed references. An example where it causes a problem is when calculated a column percent with a fixed reference to a row - and then copying the table to a new row. "JulieD" wrote: Hi AK not AFAIK, however F4 is the shortcut key for this and takes you through a cycle of A1 - column & row relative $A$1 - column & row absolute A$1 - column relative & row absolute $A1 - column absolute & row relative would using a mixed absolute / relative reference solve your problem? Cheers JulieD "AK" wrote in message ... I often have to fix and then unfix cell references using the $ sign to fix and then find and replace to unfix. Is there a menu option to fix column / fix row / fix reference (and unfix). If there is I cant find it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to Copy COUNTA() with cell references | Excel Worksheet Functions | |||
Finding Cell References | Excel Discussion (Misc queries) | |||
Cell References in Functiona | Excel Worksheet Functions | |||
Excel: how to formulate conditional cell references | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |