Thread: paste without formular
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default paste without formular
Select the range of data to copy or CTRL + a(twice in 2003) to select all
cells.

EditCopy

Switch to other sheet, select a cell and EditPaste SpecialValuesOKEsc.


Gord Dibben MS Excel MVP

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

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

Reply With QuoteReply With Quote