Sometimes data that you have in Columns may look better in Rows, or vice versa.
To transpose Columns to Rows (or Rows to Columns) in Excel, is very easy. To do this, follow these simple steps:
1. Highlight the data you wish to transpose.
2. Click the Copy button.
3. Click into an empty cell (Note: it must be in a location separate from your current data or you may run into problems).
4. Right-click and choose "Paste Special".
5. On the Paste Special sub-menu, click the "Transpose" check box and click OK.
Remember, for this to work your data must truly be in a data format. If there are Blank Rows or Columns and/or the data is all in One Column or Row, the Transpose feature will not know what to do with your data.
Subscribe to:
Post Comments (Atom)
-
I often hear people say "I no longer see the Forward, Reply, and Reply to All buttons on my emails. How do I get this information back?... -
I've had a few people ask me lately how to filter lists using Excel. It really is as simple as clicking a button on the Ribbon. If you...
-
When Outlook is first setup, the default Auto-Archive is 6 months. This means that e-mails dated 6 months ago will automatically be moved...
No comments:
Post a Comment