Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copy Excel worksheets
When copying an Excel worksheet from one spreadsheet to another, how does one
copy only formulas and no values ? Using the copy, paste special/formulas always includes the values. |
#2
|
|||
|
|||
You can't copy only formulas with them not returning what they refer to. If
you mean that you don't want the formulas to refer to the sheet where they were copied from (if you have =A1 in sheet1 and you want to copy that but don't want to get =Sheet1!A1) , do an editreplace, then replace = with let's say r=, now select the whole sheet and copy, paste intoa new sheet. reverse the replace with find r= replace with = in both sheets Regards, Peo Sjoblom "TedDSC" wrote: When copying an Excel worksheet from one spreadsheet to another, how does one copy only formulas and no values ? Using the copy, paste special/formulas always includes the values. |
#3
|
|||
|
|||
When copying an Excel worksheet from one spreadsheet to another, how
does one copy only formulas and no values ? Using the copy, paste special/formulas always includes the values. Maybe a two-step process will meet your need. 1. Do an ordinary copy/paste, getting both values and formulas. 2. Get rid of the values by doing: Edit Go to Special Constants Hit the Delete key |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I save an editable copy of a protected excel workbook? | Excel Discussion (Misc queries) | |||
Copy Word table into Excel cell by cell | Excel Discussion (Misc queries) | |||
How do I copy excel macros from one pc to another? | Excel Discussion (Misc queries) | |||
Color of Excel BEHIND the worksheets!! | Excel Discussion (Misc queries) | |||
Linking to Worksheets on Excel -Saved Web Page | Links and Linking in Excel |