excel courses - Changing Rows to Columns and vice versa

Resolved · Low Priority · Version Standard

Wed 6 Dec 2006, 14:42 Delegate David said...

David has attended:
Word Advanced course
Excel Intermediate course

Changing Rows to Columns and vice versa

If after creating a spreadsheet, I find it I have laid it out badly and want to swap rows for columns or vice a versa is this possible and how?

Wed 6 Dec 2006, 15:52 Trainer Richard said...

RE: Changing Rows to Columns and vice versa

Yes,

Select the cells in the column you want to make into a row

click in a clear area, and right click > Paste Special
Tick the TRANSPOSE box
OK

done.

Excel tip:

Autofit column width – Excel (all versions)

a. Highlight the column or columns you wish to alter the width of. You do this by clicking on the grey button at the top of the column showing the column letter. Click and drag on these letters to select more than one column.
b. Double click the dividing line between the columns. This dividing line is the break between the columns on the column headers (grey buttons showing the column letter at the top of each column). When you hover your mouse over one of these dividing lines the point will change and show an arrow pulling a line in two directions. When you have this mouse pointer you should double click to get Excel to automatically set the column width to fit the contents of the column (autofit)

View all Excel hints and tips

excel courses - Changing Rows to Columns and vice versa

Changing Rows to Columns and vice versa

RE: Changing Rows to Columns and vice versa

Excel articles

Excel tip:

Autofit column width – Excel (all versions)