worksheet copy problem

  • Thread starter Thread starter jim apostolidis
  • Start date Start date
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
 
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
 
Back
Top