Transpose and Link??

  • Thread starter Thread starter Ket
  • Start date Start date
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
 
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
 
Back
Top