duplicate table just values not formulas in the table

R

Rob

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
 
D

Del Cotter

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
Click to expand...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embed the same Excel multiple times 0
List all tables, including document structure 0
Newbie Help - IF Yes No Function 0
VB Script reference cells for in current table? 1
Copy addition formula of non-consecutive horizontal cells 2
How to paste this down? 3
Use TODAY() function as the criteria in a SUMIF formula 1
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2

Top