How do I switch Excel from rows to columns or columns and rows? (Transpose)

1. Copy all the cells you wanted to switch/invert in Excel and copy them
2. Instead of pasting them, use the Paste Special button and select "Transpose" into the cells you want them in.

This might not be the most effective solution to do what you may be specifically wanting to do but please do give the Transpose feature a go and try to save some time.

You may also need to fiddle around with the space and cells in which you're copying or pasting to and from.