| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I transpose reference cells by Auto-fill?
Thx! both answers is work
-- CKKwok "Jarek Kujawa" wrote: another way presume yr auto-filled area (=A1,=B1...) is in A2, B2,... select $A$2:$H$2 area, go to formula bar and insert the formula (this is an array formula so CTRL+SHIFT+ENTER it) =TRANSPOSE($A$2:$H$2) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto-fill a sheet reference | Excel Worksheet Functions | |||
| Auto fill in cells | Excel Discussion (Misc queries) | |||
| Auto fill cell reference | Excel Discussion (Misc queries) | |||
| How to transpose a list of reference cells without changing the li | Excel Discussion (Misc queries) | |||
| Using Index to Transpose, Update Reference Cells as you Drag Down | Excel Worksheet Functions | |||
Threaded Mode
