Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Swapping headers
Is there a way to swap the column and row names so that I can click/drag
ascending nunbers horizontally and letters vertically? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Swapping headers
In cells A 1 to A 5 type:-
1 2 3 4 5 Highlight the above cells and then Ctrl-C to copy. Go to cell H 5 (for example). Home / Paste / Transpose / the numbers 1 to 5 will now appear horizontally. In cells A 6 to E 6 type:- abcde Highlight the above cells and then Ctrl-C to copy. Go to cell K 9 (for example). Home / Paste / Transpose / the letters a to e will now appear vertically. I am not sure from your posting if the above is what you want. If my comments have helped please hit Yes. Thanks. "Darren" wrote: Is there a way to swap the column and row names so that I can click/drag ascending nunbers horizontally and letters vertically? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Swapping headers
Sorry Trip-To-Tokyo, my question was not clear enough. I want to swap the
actual line/column titles so that letter are down and numbers are across. or have a way of copying down letter/copying across numbers. But thankyou for the reply. "trip_to_tokyo" wrote: In cells A 1 to A 5 type:- 1 2 3 4 5 Highlight the above cells and then Ctrl-C to copy. Go to cell H 5 (for example). Home / Paste / Transpose / the numbers 1 to 5 will now appear horizontally. In cells A 6 to E 6 type:- abcde Highlight the above cells and then Ctrl-C to copy. Go to cell K 9 (for example). Home / Paste / Transpose / the letters a to e will now appear vertically. I am not sure from your posting if the above is what you want. If my comments have helped please hit Yes. Thanks. "Darren" wrote: Is there a way to swap the column and row names so that I can click/drag ascending nunbers horizontally and letters vertically? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
swapping axis' | Charts and Charting in Excel | |||
Swapping Columns | Excel Discussion (Misc queries) | |||
swapping fomulas for values | Excel Discussion (Misc queries) | |||
swapping columns?? | Excel Discussion (Misc queries) | |||
Swapping rows and columns | Excel Worksheet Functions |