To make horizontal rows into vertical columns, highlight the cells you want to change, copy, right click cell you want to move to, select ‘paste special’, click ‘transpose’ box, hit ok. It's that simple!
Join our free email newsletter for more advanced Excel tips to make your life easier! Don't worry, we won't swamp your inbox and you can unsubscribe at any time. We'll even send you some useful Excel templates from time to time. Cheers!
Join our free email newsletter for more advanced Excel tips to make your life easier! Don't worry, we won't swamp your inbox and you can unsubscribe at any time. We'll even send you some useful Excel templates from time to time. Cheers!
right on, thanks!
ReplyDeleteThis comment has been removed by a blog administrator.
DeleteThanks... solved my problem in first search..!!
ReplyDeleteGreat, so simple, when you know how!! Thanks
ReplyDeleteHow about vice versa my headings are vertical and I want to move them horizontal and the text to go with them;
ReplyDeleteName Jim Rex
Position and Company Visionary Leader for Rapid Growth
View View Jim's Profile
Area Greater San Diego Area
Industry Health, Wellness and Fitness Industry
Email jrexjr@san.rr.com
Too bad they ruined this in the update to 2010
ReplyDeleteThis comment has been removed by a blog administrator.
ReplyDeleteThis comment has been removed by a blog administrator.
ReplyDelete