Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel courses - Changing Rows to Columns and vice versa

excel courses - Changing Rows to Columns and vice versa

ResolvedVersion 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:

Quick Absolute Cell References

When entering cell references in a formula you probably click the cell, or you may type in the cell reference. If you require any of the 4 variations, press the F4 key now before you press Enter to toggle around the relative and absolute entries ($signs).

Note that the F4 key outside of editing a formula is the Repeat key to repeat a previous action.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

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:

Quick Absolute Cell References