#Microsoft365 – Ever need to change data in Excel displayed as columns to rows? No retyping necessary. This is very easy to accomplish with Paste Special – Transpose.

For previous posts in my #Microsoft365Challenge go to the index page.

DISCLAIMER:  I WRITE ARTICLES ABOUT OFFICE / MICROSOFT 365. CONTENT IS ACCURATE AT TIME OF PUBLICATION, HOWEVER UPDATES AND NEW ADDITIONS HAPPEN DAILY WHICH COULD CHANGE THE ACCURACY OR RELEVANCE. PLEASE KEEP THIS IN MIND WHEN USING MY BLOGS AS GUIDELINES.

All you have to do is select the data (1), Right-click > Copy (2), Right-click > Paste Special (3), Transpose (4). And voila!! (5).

Transpose 1

It is also possible to copy and paste tables of data in the same way:

Transpose 2

Purpose of this blog challenge:  I will write 365 blogs in 365 days around Microsoft 365. I did a similar challenge with Office 365, blogs can be found here. I won’t just be talking about the new Microsoft 365 subscription model. I will be sharing any news, tips and tricks around Office / Office 365 / Windows / Mobility and Security. And let’s not forget all the great new Apps & services available.  A lot of what I’ll share on Office and SharePoint will also be applicable to none “Office 365” versions.

Advertisements