ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to copy worksheet or workbook without formulas (https://www.excelbanter.com/excel-discussion-misc-queries/59957-how-copy-worksheet-workbook-without-formulas.html)

Outapin

How to copy worksheet or workbook without formulas
 

Hi,

Is there a way that I can copy a worksheet or a selection of it, with
everything except the formulas ?
I have tried the copy - paste special - values and then Formats but i'm
missing my graphs. Is there a way that we can copy everything as an
object or something similar ?

Thanks,


--
Outapin
------------------------------------------------------------------------
Outapin's Profile: http://www.excelforum.com/member.php...o&userid=29278
View this thread: http://www.excelforum.com/showthread...hreadid=492744


CLR

How to copy worksheet or workbook without formulas
 
Try...........Ctrl-Shift-Edit CopyPicture...........

Vaya con Dios,
Chuck, CABGx3



"Outapin" wrote:


Hi,

Is there a way that I can copy a worksheet or a selection of it, with
everything except the formulas ?
I have tried the copy - paste special - values and then Formats but i'm
missing my graphs. Is there a way that we can copy everything as an
object or something similar ?

Thanks,


--
Outapin
------------------------------------------------------------------------
Outapin's Profile: http://www.excelforum.com/member.php...o&userid=29278
View this thread: http://www.excelforum.com/showthread...hreadid=492744




All times are GMT +1. The time now is 12:43 PM.

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