Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() I wish to copy formula and keep the same references ie cell F2 has formula =sum(B2:D2) copy this to cell G6 so that cell G6 shows =sum(B2:D2) but when I copy and paste cell G6 shows =sum(C6:E6) -- macsworks ------------------------------------------------------------------------ macsworks's Profile: http://www.excelforum.com/member.php...o&userid=29235 View this thread: http://www.excelforum.com/showthread...hreadid=489656 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Change the cell references to be absolute: $B$2:$D$2 instead of B2:D2.
(Highlight the references up in the formula bar and hit the F4 key). "macsworks" wrote: I wish to copy formula and keep the same references ie cell F2 has formula =sum(B2:D2) copy this to cell G6 so that cell G6 shows =sum(B2:D2) but when I copy and paste cell G6 shows =sum(C6:E6) -- macsworks ------------------------------------------------------------------------ macsworks's Profile: http://www.excelforum.com/member.php...o&userid=29235 View this thread: http://www.excelforum.com/showthread...hreadid=489656 |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() thanks to bpeltzer problem solved -- macsworks ------------------------------------------------------------------------ macsworks's Profile: http://www.excelforum.com/member.php...o&userid=29235 View this thread: http://www.excelforum.com/showthread...hreadid=489656 |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Another option is to copy your formula from the Formula Bar at the top.
Copying from the formula bar does not put Excel into Linking mode. HTH. :) -- Dana DeLouis Win XP & Office 2003 "macsworks" wrote in message ... thanks to bpeltzer problem solved -- macsworks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copy cells with formula without references | Excel Worksheet Functions | |||
How do I copy a cell + it's formula from one workbook to another? | Excel Discussion (Misc queries) | |||
copy formula and get value instead | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
How do you copy a formula without incrementing some constants? | Excel Worksheet Functions |