Phone: 847-749-1427  
Fax: 847-749-3464  

Home

Training Programs

KEPT Training Method

Clients Served

Tips & Tricks

About Us

Contact Us

   
       
 
     

Transpose Row and Column Headings

Many times we design a spreadsheet with column headings (which are horizontal) then decide those headings should be row headings (vertical) or vice versa.

The solution is easy!

  1. Select the column or row that you want to Transpose
  2. Click the Copy icon
  3. Click into the cell where you want to begin
  4. Click Edit
  5. Choose Paste Special
  6. Choose "Transpose"
  7. Click OK
 
     

First Choice/Your Choice packs tips like these into their computer training programs throughout the Chicago area. For timely assistance with individual questions, the Help, I'm Stuck application support program is available nationwide.

Return to the main Tips & Tricks page