Tarsier Tools
Transpose Link Tool
Overview Designed for Microsoft Excel, this "Tarsier Tool" will enable you to transpose a row of cells to a column, and vice versa, while at the same time, maintaining a link between the destination range and the original range. The link can be made on the same sheet, a different sheet in the same workbook, or even in a different workbook. This is different from the Excel Paste Special... Transpose function that pastes the values in the original range into the transposed destination range.

For example, this tool could be used if you are using Excel to do your company finances. If you find it easier to list your expenses in columns, and the months in rows, and then to finally sum up in the final column; without my Transpose Link Tool, you would have to manually link each row total to each column entry in your horizontal Cash Flow, Balance Sheet, etc. spreadsheet.

The tool includes Help. If you need it just click on the Help button on the tool's menu bar. Additional information will be provided on this page if it is needed.

Please note that this Tarsier tool is distributed with NO WARRANTY.

This page contains the following information on this Tarsier Tool.
Usage Instructions
License Fee
How to Install
How to Un-install
Revision History
Software for Download
Source Code
Technical Support
Further Information

Usage Instructions To use the Transpose Link Tool:
  1. Select the row or column of cells you want to transpose,
  2. Click on the Copy button on the TSS Transpose Link Tool toolbar, or
    Right-Click the selection and select Copy to Transpose.
  3. Select the cell where you want the transposed row/column to be transposed to, (this can be on any sheet in any workbook).
  4. Click on the Paste button on the TSS Transpose Link Tool toolbar, or
    Right-Click and select Transpose Selection.

The selected row or column of cells to transpose is kept after pasting allowing multiple pastes of the same source data.

Error Messages When you use the Transpose Link Tool, you can get error messages due to the following,

  1. A Microsoft Excel spreadsheet only has 256 columns, (A to IV). If you try and transpose more than 256 rows a message box will appear telling you that "You can not transpose more than 256 rows.". You must go to the original data and select less than 256 rows and try again.
  2. Similarly, the further to the right of the first column you start, the lower the number of rows you can transpose. If the starting column plus the number of rows exceeds 256, a message box will appear telling you that "You can not transpose more than ### rows when starting from this column." (where ### = a number). You must go to the original data and select less than the indicated number of rows and try again.
  3. A Microsoft Excel spreadsheet only has 65536 rows. If the starting row plus the number of rows exceeds 65536, a message box will appear telling you that "You can not transpose more than ### columns when starting from this row." (where ### = a number). You must go to the original data and select less than the indicated number of columns and try again.
  4. The Transpose Link Tool only allows you to transpose a single row or column of data. You can not transpose a rectangle of cells. If you try, the following message will appear, "You can only transpose a column to a row, or a row to a column, not a block of cells.".
License Fee This "Tariser Tool" is licenced under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License. There is no license fee for personal use of this tool. However, if you are using this software within software that you are developing and intend to sell, please e-mail me for details of the license fee.

How to Install
  1. Download the appropriate Transpose Link Tool for your version of Windows and Excel from the Software for Download section of this page. Use the save this file to disk option to save the file to a directory on your computer where you'll be able to find it later. (A good location to save the file to is your Microsoft Excel Add-In directory, which can be found by completing steps 2, and 3.)
  2. Start Microsoft Excel, and from the Tools menu, select Add-Ins...,
  3. Click on the Browse... button, which will list all the non Microsoft Excel Add-Ins,
  4. A. If you saved the file to your Microsoft Excel Add-In directory, select TT01-003.xla from the list of files and click the OK button,
    B. If you saved the file to another directory, change to that directory in the same way that you would use the Open file dialog to open a file; then select TT01-003.xla from the list of files and click the OK button,
  5. Ensure that the box for the "TSS Transpose Link Tool" is ticked/checked, as shown below, and click OK

The tool's menu bar will appear and can be controlled like any Excel menu bar. It will be removed when the Add-In is "unloaded", see the Un-install Instructions.

My Transpose Link Tool is now ready for use.

How to Un-install To un-install the Transpose Link Tool,

  1. Start Microsoft Excel, and from the Tools menu, select Add-Ins...,
  2. Un-tick/un-check the box for the "TSS Transpose Link Tool" and click OK. The menu bar will disappear, and the tool will not be loaded the next time Excel is started.

If you decide that you want to use the Transpose Link Tool again, just perform steps 2 and 5 from the How to Install Procedure.)

If you want to remove the TSS Transpose Link Tool reference from the list of Add-Ins,

  1. Delete the file TT01-003.xla from your computer,
  2. Start Microsoft Excel, and from the Tools menu, select Add-Ins...,
  3. Try to tick/check the box for the "TSS Transpose Link Tool" the following message will appear, "Cannot find add in 'directory path\TT01-003.xla'. Delete from list?". Click Yes,
  4. Close the Add-In dialog box by clicking OK.
Revision History
Rev Date Description
1.0 12-Nov-01 Initial Version Released

Software for Download
Windows Ver. Excel Ver. Software
Win NT 4 Excel 97 TT01-003.xla  (71k)
Win98 Excel 2000
Windows XP Pro Excel 2003

Please let me know if you have used my Linear Interpolation Function, successfully or not, on any other Windows and Excel combination.

Source Code In accordance with the GNU General Public License the Microsoft Excel Add-in used to distribute this Tarsier Tool is not password protected allowing you to view and modify it if you require. You should review the GNU GPL to determine your rights to distribute this software and be informed that this software is distributed with NO WARRANTY.

Technical Support Frequently Asked Questions Currently there are no FAQ for this tool. If you have a question, please e-mail it to me. Please ensure that you identify that the question is about my Transpose Link Tool (TT01-003).

Bug Reports If you suspect a bug in this Tarsier Tool, before contacting me, please check the FAQs and Bug Reports to see if it has already been identified. If it hasn't, e-mail me a description. Please ensure you identify the Tarsier Tool, (Transpose Link Tool TT01-003), the operating system and spreadsheet program in the e-mail and include as much detail as possible; including a simple example application is always helpful! but make sure it does not contain proprietary or confidential information.

Currently there are no reported bugs for this Tarsier Tool.

Further Information This section will be updated with links to information relating to the principles behind and the uses of this Tarsier Tool, as I become aware of them.

Back to Available Tarsier Tools

Copyright ©2001 Tarsier Software Solutions Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License
Creative Commons Licence