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
|
|||
|
|||
Copy / Paste Merged Cells
Using Excel 2000, is is possible to copy and paste a range
which has merged cells such that the pasted data displays only values. When using paste special and the "formula" option, merged cells will paste into the destination without problems but when using paste special with the "value" option, merged cells will not paste. Is there a way to do this easily and if so, what is it? Thx. |
#2
|
|||
|
|||
Copy / Paste Merged Cells
Maybe you can copy from the formula bar and paste into the formula bar???
LPS wrote: Using Excel 2000, is is possible to copy and paste a range which has merged cells such that the pasted data displays only values. When using paste special and the "formula" option, merged cells will paste into the destination without problems but when using paste special with the "value" option, merged cells will not paste. Is there a way to do this easily and if so, what is it? Thx. -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copy and Paste | Gilbert Aponte | Worksheet Functions | 1 | June 18th, 2004 09:35 PM |
Copy & Paste from the clipboard | Guinn | General Discussion | 1 | May 25th, 2004 11:57 AM |
copy & paste from other worksheet - but not allow to cut | Worksheet Functions | 0 | April 28th, 2004 03:42 PM | |
Counting Number of Cells Including Merged Cells | Daniel D. | Worksheet Functions | 12 | February 24th, 2004 01:27 AM |
How do you copy & paste the subtotal amount only? | [email protected] | Setting up and Configuration | 1 | December 3rd, 2003 03:56 PM |