Is there an easy way to copy a worksheet where all formulas are replace with the resulting values?
K kretzb Dec 18, 2007 #1 Is there an easy way to copy a worksheet where all formulas are replace with the resulting values?
A andré mulder Dec 18, 2007 #2 kretzb said: Is there an easy way to copy a worksheet where all formulas are replace with the resulting values? Click to expand... copy, paste special, values finish!! this what you mean?
kretzb said: Is there an easy way to copy a worksheet where all formulas are replace with the resulting values? Click to expand... copy, paste special, values finish!! this what you mean?
B Bob Dec 18, 2007 #3 yes, rightclick on the tab of your worksheet and choose "move or copy" then click on the selection box "create a copy" press CTRL+A to select all data and then copy and paste special - values
yes, rightclick on the tab of your worksheet and choose "move or copy" then click on the selection box "create a copy" press CTRL+A to select all data and then copy and paste special - values
