Bach up your file. then
Highlight and Cut the range you want to move. A1:M1
(Assuming range A2:A13 is clear of data)
With your active cell (cursor) still in A1 Go to menu, Edit Paste-Special,
Check Transpose box near bottom of screen, OK
Best way to learn it's features:
Open a New Workbook, enter in cell a1 123.
With cursor on A1 select Copy,
then go to the menu, edit paste-special.. and the dialog box will come up
showing all features available to you.. In the upper right-hand corner of
the box you will see a "?"
left-click on it and then move to each choice (one-by-one) and left-click on
them; as you do an explanation follow (in a pale-yellow box).
After reading, left-click inside the pale-yellow box and the box is turned
off. Then again back to the ? and go to the next choice; go thru them all.
That's me suggestion (for starters)...
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
