Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to copy paste without data (functions) changing : calc

When I copy (Data:Column - Rows) and paste right below prior data why do all my functions change.

How do I prevent this from happening.

Some functions I'm able to put "$" and it will keep the function (command) but I cannot do this for all functions (=sum( ))

How do I copy / paste without any data changing within the copied cells when I paste to a new row.

Purpose: trying to see overall data and sorted data in the same document.

thank you in advance for any help anyone provides.