A Time-Saving, One-Click Excel Trick

Last Updated Apr 19, 2011 12:08 PM EDT

Sometimes it's the simplest things that leave me completely stymied. Often, for example, I will copy data into Excel and wish it was arranged horizontally rather than vertically. Usually, I will painstakingly copy the fields from their single column into a single row. Recently, I discovered what should have been obvious -- there's a single click way to do this automatically.

As Productivity 501 points out in a short 1-minute tutorial video, it's a simple matter of using the Paste Special command. Here's how:

  1. Copy the cells that you want to transpose, either from a column to a row or from a row to a column.
  2. Click the cell where you'd like to start pasting the new column or row.
  3. Right-click and choose Paste Special.
  4. In the Paste Special dialog box, click Transpose and then click OK.
That's it. Personally, I have never seen this dialog box before; I've always just chosen items from the Paste Special fly out menu. Hopefully this will save you as much time as it has saved me since discovering this little gem.

More on BNET: