- Worldstart's Tech Tips And Computer Help - http://www.worldstart.com -

Wrong Way

Wrong Way!

Have you ever found yourself happily working along in MS Excel only to realize that you’ve set the data up totally wrong?

You know, what should be vertical is horizontal and vice versa.

What do you do?

Start retyping?

I hope not!

Do you start copying and pasting each cell’s contents to its new location? Or maybe you just drag each item to its new home?

Either way, it’s time consuming.

Would you like a quick way to make a data direction change?

Good! I was hoping you’d say yes.

Here’s the deal. Switching direction is all in the way you paste.

Yep, I said paste. But don’t worry, we get to copy and paste entire sections of data all at once, not item by item.

Make sure to check the Transpose box and click OK.

Instantly you should be returned to your worksheet with the data pasted in the new direction.

It’s almost like a U-turn for Excel, without the risk of a traffic violation!


~ April