Transpose your data

You can turn your Excel data on its side – literally! When you use the Transpose optionĀ from the Paste Special dialog box you can turn data from a Horizontal Orientation to Vertical one – or vice versa. It’s easy to do this as you will see in this video.

Here are the steps to follow for today’s tip:

1) Select the data area and copy it to the clipboard

2) Right-click a blank cell in an open area of your worksheet

3) Select “paste special” and check the “transpose” box and then click OK

Find the video lesson that you want – Index to all Excel Topics

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Speak Your Mind