copy cells with formula without references
I wish to copy cells containing formula to another cell but when I paste I want the the formula I to have the same references as the original cell -- macsworks ------------------------------------------------------------------------ macsworks's Profile: http://www.excelforum.com/member.php...o&userid=29235 View this thread: http://www.excelforum.com/showthread...hreadid=489578 |
copy cells with formula without references
Instead of, for example, =A1, use =$A$1
This can also be achieved by pressing F4 when the cursor is on the address in the formula bar. -- Kind regards, Niek Otten "macsworks" wrote in message ... I wish to copy cells containing formula to another cell but when I paste I want the the formula I to have the same references as the original cell -- macsworks ------------------------------------------------------------------------ macsworks's Profile: http://www.excelforum.com/member.php...o&userid=29235 View this thread: http://www.excelforum.com/showthread...hreadid=489578 |
All times are GMT +1. The time now is 03:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com