|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 26th, 2005, 04:50 PM
|
|||
|
|||
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
October 26th, 2005, 10:43 PM
|
|||
|
|||
|
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
October 27th, 2005, 12:47 AM
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Can't Copy and Paste or Paste Special between Excel Workbooks | wllee | General Discussion | 4 | April 5th, 2005 07:51 PM |
| Can't Copy and Paste between Excel 2003 Workbooks | wllee | General Discussion | 6 | March 30th, 2005 02:59 PM |
| In Excel protect or unprotect multiple tabs with one password at . | Tony-EPIC | Worksheet Functions | 1 | September 16th, 2004 04:12 PM |
| Copy Formulas to Paste as Values to return # not text | Kohai | Worksheet Functions | 4 | August 26th, 2004 03:01 PM |
| STORE multiple values from a lookup table to another table. | beller | Database Design | 0 | June 15th, 2004 04:42 AM |
Linear Mode
