Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy formula using same references
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
|
|||
|
|||
copy formula using same references
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
|
|||
|
|||
copy formula using same references
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
|
|||
|
|||
copy formula using same references
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 | |
|
|
Similar Threads | ||||
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 |