| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do I transpose a row of cells to a column between worksheets?
I want to transpose a row of cells (containing a formula) from one worksheet
into a column of cells in another worksheet. How do I do this? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do I transpose a row of cells to a column between worksheets?
Depending what is needed:
Use Copy followed by Edit | Paste Special with Transpose selected or use the TRANSPOSE function - see Help for more then come back if you need more best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Mike C" <Mike wrote in message ... I want to transpose a row of cells (containing a formula) from one worksheet into a column of cells in another worksheet. How do I do this? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do I transpose a row of cells to a column between worksheets?
=INDEX(Sheet1!$1:$1,ROWS($1:1))
Entered in A1 of Sheet2 and copied down column A Gord Dibben MS Excel MVP On Thu, 13 Sep 2007 08:08:04 -0700, Mike C <Mike wrote: I want to transpose a row of cells (containing a formula) from one worksheet into a column of cells in another worksheet. How do I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transpose cell contents from multiple worksheets into rows | Excel Worksheet Functions | |||
| Merging text cells from two worksheets with one shared column | Excel Worksheet Functions | |||
| transpose links from a column to a row | Excel Worksheet Functions | |||
| transpose column to a row? | Excel Discussion (Misc queries) | |||
| transpose 3d cells to a column in single workbook | Excel Discussion (Misc queries) | |||
![Mike C[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
