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 |
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 |