Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

first answer does not work....formulas in tables are fixed references...moreover, you need to copy the actual forumula....copying the cell copies the contents but not the forumula

I ran into this same desire/problem yesterday (3.5.2 on XP). ended up having to manually copy formula and edit the formula to pick up the right cell references.

Better off to use calc and copy and paste...though formatting brings new challenges.