| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I transpose reference cells by Auto-fill?
Hi Folks,
for example, satrt from a reference =A1 then Auto-fill right (Ctrl+R), I can get =B1, =C1...and so on, is there any easy way that I could got the same result list in same column as: =A1 =B1 =C1 .... but Auto-fill down (Ctrl+D) as; =A1 =A2 =A3 .... What I'm doing now silly is to edit each cell =A$1, =B$1...copy...paste special...transpose... -- CKKwok |
| 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
