Hi, I was wondering how to change the alignment of cells. Instead of them being aligned vertically I want them to be aligned horizontally. e.g.
instead of
1
2
3
4
5
I want
1 2 3 4 5
Thanks
Hi, I was wondering how to change the alignment of cells. Instead of them being aligned vertically I want them to be aligned horizontally. e.g.
instead of
1
2
3
4
5
I want
1 2 3 4 5
Thanks
Hi Raptors, welcome to the forum.
You could use the Transpose function for this. Easiest method is to select your range, say A1:A5 and copy it (CTRL+C). Right-click another cell, let's say B1, and choose PasteSpecial, select Transpose (lower right corner of pop-up window) and click OK.
Also, please take a moment to read the forum rules. Cross posting without a link is not permitted here. I can only assume this is your post on another forum as the request and time match within minutes.
http://www.mrexcel.com/forum/showthread.php?p=2430292
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks