Is there a way that i can copy multiple cells horizontaly, then paste them verticaly into cells?
S Slumbering Gorilla Nov 24, 2004 #1 Is there a way that i can copy multiple cells horizontaly, then paste them verticaly into cells?
J JE McGimpsey Nov 24, 2004 #2 one way: Copy the horizontal cells. Select the first vertical cell (not in the horizontal range). Choose Edit/Paste Special. Check the Transpose checkbox. Click Ok.
one way: Copy the horizontal cells. Select the first vertical cell (not in the horizontal range). Choose Edit/Paste Special. Check the Transpose checkbox. Click Ok.
