worksheet copy problem

J

jim apostolidis

Hi everyone...
I need to know if its possible to save a worksheet to another worksheet
without saving the formulas, just values (and the format of the cells )
Thanks anyway
 
P

Peo Sjoblom

One way,

right click the sheet tab and select move or copy, select create a copy,
move it to desired location in the workbook, select the whole copied sheet
by clicking the select all button or by pressing ctrl + a,
do edit>copy and while still selected do edit>paste special and select
values and number formats
 
Top