- Worldstart's Tech Tips And Computer Help - http://www.worldstart.com -
Posted By On February 24, 2006 @ 2:55 PM In MS Excel,MS Office Help | Comments Disabled
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?
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.
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!
Article printed from Worldstart's Tech Tips And Computer Help: http://www.worldstart.com
URL to article: http://www.worldstart.com/wrong-way/