| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to transpose forumlas
If this is possible, please let me know Example: I would like to copy cells B1-B3 and Transpose them to D1-F1 without the formulas updating. A B C D E F G 1 124 =A1 =A1 =A2 =A3 2 275 =A2 3 806 =A3 As I am typing this I am thinking if I format B1-B3 as text then transpose then format to number, this might work. If anyone knows a quicker way i would appreciate it. Thank you. -- iturnrocks ------------------------------------------------------------------------ iturnrocks's Profile: http://www.excelforum.com/member.php...o&userid=37246 View this thread: http://www.excelforum.com/showthread...hreadid=570522 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help using Transpose | Excel Discussion (Misc queries) | |||
| Want to Transpose | Excel Discussion (Misc queries) | |||
| I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES | Excel Worksheet Functions | |||
| transpose a column into many rows | Excel Discussion (Misc queries) | |||
| TRANSPOSE() | Excel Worksheet Functions | |||
Threaded Mode
