Copy cells containing formulas
Posted by Dee on October 28, 2001 6:07 AM
In Lotus 123 when I copy cells/rows containing formulas which include reference to other cells the cells/rows that I paste them to reflect the new cells in my formulas. In Excel the cells that I paste them to do not reflect the new cells but copy the exact cells/rows that I copied from. The formulas do not contain any $ signs. How do I get Excel to do what Lotus 123 does for me?
Posted by Dee on October 28, 2001 9:39 AM
I think i've found the answer to my question, but if you would like to comment I'd appreciate it. Thank you
Posted by Jonathan on October 28, 2001 2:39 PM
I don't know. In Excel it always works for me the way you describe it working in Lotus. The references are relative and they change appropriately, unless, of course, they have the $ signs indicating that the references are absolute.
What did you figure out?
Posted by Dee on October 29, 2001 5:40 AM
Apparently I made a mistake because it works in the worksheet I just pulled up. I don't know why it didn't work previously. Thank you for your prompt response. This is a great forum for a newbie Excel user!
