Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

answered 2012-12-12 01:59:45 +0200

ROSt52 gravatar image

As you use in your spreadsheets the same structure a possibility is to

1 - add a character before the "=" sign in front of the formula e.g. a=sumif(.........)

2 - copy and paste the cell content, which is not a formula anymore

3 - remove the character in front of the "=" sign

I use this trick often to avoid any problems with wrong links to cells.