duplicate table just values not formulas in the table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

duplicate a table with the just values not formulas in the table so that I
don't have to readjust the formulas as when they are copied and pasted they
are often meaning less ie referring to the wrong cells
 
Rob said:
duplicate a table with the just values not formulas in the table so that I
don't have to readjust the formulas as when they are copied and pasted they
are often meaning less ie referring to the wrong cells

a) it's in the manual, Copy, Paste Special, Values.
b) wrong newsgroup, this is microsoft.public.excel.charting. try
microsoft.public.excel.misc
 
Back
Top