Home Archives for Transpose data
October 18, 2009 Leave a Comment

Use the Transpose Feature to Change the Orientation of Data Imported into Excel

I am working through the special requests that viewers have sent me. In this lesson, I show you how to:

  • Use Data – Get External Data – to import a simple delimited text file.
  • Use Copy – Paste Special – Transpose – to make a copy of the imported data that is now “vertically oriented.” i.e. The field entries run down the column rather than across the rows.
  • Use the Data – Text-to-Columns feature to break an “address block” (City, State, Zip Code) that is one cell into three distinct cells. This is a terrific time saver!

Now available for purchase: My DVD “The 50 Best Tips, Tricks, and Techniques for Excel 2007”

Over 5 1/2 hours of training. Each video lesson focuses on one tip and averages 6 minutes.

Now available from the online store at www.thecompanyrocks.com

Related Videos

Link to this post!
Filed Under: Excel Training, Import Data into Excel, Integrating MS Office Programs, Video Response to Viewers Tagged: , , , , , ,
December 19, 2008 Leave a Comment

Select Excel Data with Keyboard & Mouse-click Shortcuts

During a recent training class, I demonstrated several Keyboard and Mouse-click shortcuts for selecting and finding data. Several people in the class had “A-Ha” moments. So, I created this video lesson to share these shortcuts with you.

Here are the steps to follow in this Excel Video Lesson:

  1. To select all of the contiguous data cells, make one cell the “Active Cell”. Ctrl+A will then select all of the cells in that data block.
  2. If you then click Ctrl+A a second time, you will select every cell in the worksheet. This is handy when you need to “AutoFit the column width in the worksheet.
  3. Use Ctrl+End to go to the last cell in your data set. Ctrl+Home will return you to the Top cell in the data set.
  4. To find a blank cell in a column, position your mouse at the bottom of the “active cell” and double-click. This takes you to the last cell that contains data in that column.
  5. To select all of the cells w/ data in a column use the Ctrl+Shift+ Down Arrow. Use the appropriate Arrow Key to select cell containing data in a Row.
  6. Quickly copy a Formula to all of the cells in the column. Position the mouse in the lower right corner of the cell with the formula and double-click.

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Related Videos

Find a specific Excel Video Lesson – Index of Excel Video Lesson Topics

NEW! Download the Excel Workbook file that I used in this lesson:

Related Video Lessons

Link to this post!
Filed Under: Excel Training, Tips and Time Savers Tagged: , , , ,
July 7, 2008 3 Comments

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

Link to this post!
Filed Under: Excel Training, Tips and Time Savers Tagged: , , ,