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