November 3, 2015
Hi fellow Excel Addict,
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.
Transpose (i.e. Swap) Your Rows And Columns
To 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:
ALT, E, S, E, Enter
| 'Spreadsheets Tips
Excel Addict' and 'Excel in Seconds' are publications of
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630