Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copy a file with only values no formulas
Is there an easy way to copy a workbook so that it only has the values and
not the formulas? Thank you. -- Lee Coleman |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copy a file with only values no formulas
Right click on a sheet tab and select all sheets. Then select all cells on
the active sheet. Do a copy, then Edit, paste special, values. Right click on a sheet tab and select ungroup sheets. Save the workbook under a different name!!!! Bob Flanagan Macro Systems http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Lee Coleman" wrote in message ... Is there an easy way to copy a workbook so that it only has the values and not the formulas? Thank you. -- Lee Coleman |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copy a file with only values no formulas
Thanks! I knew there had to be an easier way than I was trying to do it.
Thanks again. Lee "Bob Flanagan" wrote in message . .. Right click on a sheet tab and select all sheets. Then select all cells on the active sheet. Do a copy, then Edit, paste special, values. Right click on a sheet tab and select ungroup sheets. Save the workbook under a different name!!!! Bob Flanagan Macro Systems http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Lee Coleman" wrote in message ... Is there an easy way to copy a workbook so that it only has the values and not the formulas? Thank you. -- Lee Coleman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy formulas without associated values | Excel Worksheet Functions | |||
Copy Values in a cell (derived from formulas) | Excel Worksheet Functions | |||
copy worksheet to a new workbook with formulas .... but new file not point to old one | Excel Discussion (Misc queries) | |||
Can you copy multiple tabs from formulas to values w/o paste spec? | Excel Worksheet Functions | |||
How do I save a copy of an excel file without the formulas? | Excel Worksheet Functions |