| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying formulas in Columns and transpose to rows?
I have a 2007 worksheet that has formulas in a Column:
=Tally!D10 =Tally!D11 =Tally!D12 How do I transpose the formula columns to rows like: ==Tally!D10 =Tally!D11 =Tally!D12 Now when I copy and Paste special (Transpose) is translates like: ==Tally!D10 =Tally!E10 =Tally!F10 Which is not the data I need? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TRANSPOSE ROWS TO COLUMNS | Excel Discussion (Misc queries) | |||
| Transpose columns to rows using first columns repeated. | Excel Worksheet Functions | |||
| How do you transpose rows to columns? | Excel Discussion (Misc queries) | |||
| Counting Rows/Columns for Copying Formulas | Excel Discussion (Misc queries) | |||
| how do I transpose columns and rows | Excel Discussion (Misc queries) | |||
Threaded Mode
