Transpose and Link??

K

Ket

Hello,

I am using Windows/Office 2K. Is it possible to do copy -> paste
special and paste the link as well as transpose?

Presently, if I transpose, the link option is greyed out.

Any ideas on how to do this?

TIA

Ket
London
 
T

Tushar Mehta

Use the TRANSPOSE function.

If your data are in A1:A10 and you want them in C1:L1, select C1:L1 and
array enter =TRANSPOSE(A1:A10).

--
An array formula is entered with CTRL-SHIFT-ENTER rather than just
ENTER. If done correctly, XL will display curly brackets { and }
around the formula

Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

transpose and link?? 2
Transpose and Paste Link 2
How to transpose data (Row to column) without losing the cell link 3
Why can I not select transpose in excel? 1
Eliminate blanks while copy row and transpose 11
Transpose, Paste Special 2
Copy Transpose and Link Data 1
Paste Special Transpose error 1

Top