Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
global vs relative format
i am linking cells in a workbook to another workbook. the link gives me the
$c$45 format which does not allow me to copy to other cells that are contiguous. how and where do you change the format so it gives you c45 as the reference when linking? thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
global vs relative format
F4 will cycle you through the various types of references.
"globallinker" wrote: i am linking cells in a workbook to another workbook. the link gives me the $c$45 format which does not allow me to copy to other cells that are contiguous. how and where do you change the format so it gives you c45 as the reference when linking? thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
global vs relative format
I don't believe you can change the default to relative cell references.
To change one cell at a time select the address in the formula bar then use F4 to cycle through to options. To change all copied cells at once from absolute to relative use this macro. Sub Relative() Dim cell As Range For Each cell In Selection If cell.HasFormula Then cell.Formula = Application.ConvertFormula _ (cell.Formula, xlA1, xlA1, xlRelative) Next End Sub Gord Dibben MS Excel MVP On Wed, 13 Sep 2006 07:51:02 -0700, globallinker wrote: i am linking cells in a workbook to another workbook. the link gives me the $c$45 format which does not allow me to copy to other cells that are contiguous. how and where do you change the format so it gives you c45 as the reference when linking? thanks. Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Format Cell | Excel Discussion (Misc queries) | |||
Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
why does currency format change to number format? | Excel Discussion (Misc queries) | |||
Keep custom format in new worksheet | Excel Discussion (Misc queries) |