D Darren Jan 24, 2010 #1 Is there a way to swap the column and row names so that I can click/drag ascending nunbers horizontally and letters vertically?
Is there a way to swap the column and row names so that I can click/drag ascending nunbers horizontally and letters vertically?
T trip_to_tokyo Jan 25, 2010 #2 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.
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.
D Darren Jan 25, 2010 #3 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.
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.
