Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

November 3, 2015

"Success is neither magical or mysterious.
Success is the natural consequence of
consistently applying basic fundamentals"
-- Jim Rohn

Hi fellow Excel Addict,

Francis Hayes (TheExcelAddict.com)Wow! Seems like yesterday I was walking on the beach enjoying the warm sun and now, here it is November already. And that wind blowing off the ocean is COLD.

Thanks for joining me today for another few seconds on your way to building up your valuable Excel skill set. Consistent action creates consistent results.

I hope that you find valuable uses for today's tip. Please let me know what you think. I love to get feedback from my readers.

Enjoy the rest of your week and keep on Excelling,
Francis Hayes (The Excel Addict)

If you missed my last newsletter, you can click here to view it online.

You can access even more tips on my website by going to my members' page

To update your contact info, click the 'Change Subscriber Options' at the bottom of this email.

Excel in Seconds with TheExcelAddict.com

Transpose (i.e. Swap) Your Rows And Columns

Switch Or Transpose Rows And Columns in Microsoft Excel 2003, 2007, 2010, 2013, 365To change a range of cells so that the rows become the columns and the columns become the rows...

(1) Select the range;
(2) Press CTRL+C to Copy (or right-click, Copy);
(3) Select a destination cell
(4) Right-click, Paste Special…,Transpose.

Make sure that the cell you are pasting to is outside the range you are copying from.

Alternative Keyboard Shortcut for Paste Special, Transpose:
, E, S, E, Enter

Thanks for supporting this newsletter and website

Subscription Information: Spreadsheet Tips From An Excel Addict is available only to subscribers of my newsletter. To get your own copy, emailed to you weekly, please visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com

 If you would like to share this newsletter with others...
1) Share a link to this page
2) Ask your friend/colleague to visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com
3)  Post a link to TheExcelAddict.com in a company newsletter or website.

Earnings Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that for a few dollars. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are ever not completely satisfied with anything I recommend, please let me know and I will get your money back for you...GUARANTEED. You can't lose.
 'Spreadsheets Tips From An Excel Addict' and 'Excel in Seconds' are publications of TheExcelAddict.com.
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630