Microsoft KB Archive/64649

{|
 * width="100%"|

Excel: Linking Rows to Columns Using the TRANSPOSE Function
'Article ID: Q64649

Creation Date: 07-AUG-1990

Revision Date: 02-NOV-1994' SUMMARY

To link a row from one Microsoft Excel worksheet to a column on another worksheet, use the TRANSPOSE function, as follows:

 Given the data is in a row on one worksheet, highlight the same amount of cells in a column on a second worksheet.  Type the following and press COMMAND+ENTER (where &quot;filename&quot; is the name of the worksheet where the information to be linked to is located, and &quot;reference&quot; is the range of cells where the information to be linked to is located): "=TRANSPOSE(filename!reference)"

The information will be linked by an array in a column. This method can also be used when linking columns to rows. Example

 On Worksheet1, enter 1, 2, 3, and 4 in cells A1, B1, C1, and D1. On Worksheet2, highlight cells A1:A4.  Type the following and press COMMAND+ENTER: "=TRANSPOSE(Worksheet1!$A$1:$D$1)" This will link the information as an array in a column. 

Note: If the data is copied, Paste Special is chosen from the Edit menu, and the Transpose option is selected, the information will be transferred to the new document, but a link will not be maintained between the documents. MORE INFORMATION

Another method of linking rows to columns is to create a link between each individual cell.
 * }

-

"THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED &quot;AS IS&quot; WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY." '' ©1997 Microsoft Corporation. All rights reserved. Legal Notices.

''

KBCategory: kbother

KBSubcategory:

Additional reference words: noupd