paste without formular

[Tracy Lo]

Hi,

My Name is Tracy. How can i copy a spreed sheet with formular and paste to
another spreed sheet without formular?

Thanks & Regards,
Tracy Lo

 

[Gord Dibben]

Select the range of data to copy or CTRL + a(twice in 2003) to select all
cells.

Edit>Copy

Switch to other sheet, select a cell and Edit>Paste Special>Values>OK>Esc.


Gord Dibben MS Excel MVP

On Wed, 22 Oct 2008 20:08:01 -0700, Tracy Lo <Tracy