Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can you copy multiple tabs from formulas to values w/o paste spec?
I have a workbook consiting on several tabs which I want to copy into a new
workbook as values only instead of copying over the formulas. Is there a way to do this without going into each tab and doing 'paste special / values' ? |
#2
|
|||
|
|||
Can you copy multiple tabs from formulas to values w/o paste spec?
"Brent" wrote: I have a workbook consiting on several tabs which I want to copy into a new workbook as values only instead of copying over the formulas. Is there a way to do this without going into each tab and doing 'paste special / values' ? Select Edit, Move or copy sheet. Click the Copy check mark and choose New Book from the To Where drop down box. Peter Atherton |
#3
|
|||
|
|||
Can you copy multiple tabs from formulas to values w/o paste s
When you do that it copies over the formulas, I want just the values.
"PeterAtherton" wrote: "Brent" wrote: I have a workbook consiting on several tabs which I want to copy into a new workbook as values only instead of copying over the formulas. Is there a way to do this without going into each tab and doing 'paste special / values' ? Select Edit, Move or copy sheet. Click the Copy check mark and choose New Book from the To Where drop down box. Peter Atherton |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Issue with copy & paste? | Excel Discussion (Misc queries) | |||
#N/A Values : Returned by Formulas vs Entered Manually | Charts and Charting in Excel | |||
delete values in several cells without deleting the formulas | Excel Discussion (Misc queries) | |||
copy paste cell character limit | Excel Discussion (Misc queries) |