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
|
|||
|
|||
Paste and transpose data
How do you paste link data aswell as transpose it when
paste special? It wont allow you do to do both on the paste special function. |
#2
|
|||
|
|||
Paste and transpose data
Nick wrote:
How do you paste link data aswell as transpose it when paste special? It wont allow you do to do both on the paste special function. You can't. One way is to array-enter a TRANSPOSE worksheet function. Select the destination cells Type "=TRANSPOSE(" Select the source cells Type ")" and then Ctrl+Alt+Enter Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#3
|
|||
|
|||
Paste and transpose data
Or select the range of formulas you wish to transpose, do Edit / replace,
replace = with %%. then copy, paste special tranpose, select the new range that just got pasted in and do Edit / replace again, replacing %% with =. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 00/02/03 ---------------------------------------------------------------------------- Seasons Greetings and Very Best wishes to all :-) ---------------------------------------------------------------------------- "Bill Manville" wrote in message ... Nick wrote: How do you paste link data aswell as transpose it when paste special? It wont allow you do to do both on the paste special function. You can't. One way is to array-enter a TRANSPOSE worksheet function. Select the destination cells Type "=TRANSPOSE(" Select the source cells Type ")" and then Ctrl+Alt+Enter Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.553 / Virus Database: 345 - Release Date: 18/12/2003 |
#4
|
|||
|
|||
Paste and transpose data
Think Bill meant "Ctrl+Shift+Enter" in the line:
Type ")" and then Ctrl+Alt+Enter -- hth Max ----------------------------------------- Please reply in thread Use xdemechanik atyahoodotcom for email -------------------------------------------------------- |
#5
|
|||
|
|||
Paste and transpose data
Max wrote:
Think Bill meant "Ctrl+Shift+Enter" in the line: I did indeed. Thanks for the correction Max. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Thread Tools | |
Display Modes | |
|
|