Need to Change Excel Details from Vertical to Horizontal or Vice Versa?

Your boss calls you over to their office and asks that you send her a list of something that you’ve created in Microsoft Excel.  The list is in a vertical fashion, but she wants it a horizontal way instead.

You check your contact list and see that you have about 50 names in your Excel spreadsheet.  How in the world will you  get this to her in the next few minutes?

Believe me, this happened to me a few times and it took me quite a bit of time to get this done, before I discovered the Transpose function in Excel.

Here are the 4 easy steps to do this:

1. Highlight the information you want to change from vertical to horizontal or vice versa, depending on which way you need to change the information.
2. Click on an empty cell where you would like to paste the new list.
3. Right click and then click Paste Special.
   
   
4. Click Transpose!
   
   

Voila!  Now you have the opposite version (horizontal or vertical) of your list.

Give it a try yourself and see how quick it can be to manipulate information from vertical to horizontal and vice versa.

You can also find more Microsoft Excel tips and tricks here.

Subscribe to The Professional Assistant feeds or get posts e-mailed directly to you today.

Until next time,

Take care - of your clutter!


Post from: Administrative Assistant Tips