ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   paste without formular (https://www.excelbanter.com/excel-worksheet-functions/207458-paste-without-formular.html)

Tracy Lo

paste without formular
 
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

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




All times are GMT +1. The time now is 04:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com