Swap rows into columns and vice versa
Excel
When you need to swap your rows into columns or columns into rows, it can be tricky. Not only is it time consuming, but you run the risk of mixing up your data. We’ll show you how to do it in just a few clicks.
More tech tips
Excel
Always see the headings when scrolling
Find out more ➝
Excel
Easily zoom in and out
Find out more ➝
Excel
Get to the top row without scrolling
Find out more ➝
Excel
Instantly see all data in columns & rows
Find out more ➝
Excel
Speed up typing
Find out more ➝
Excel
Do super-fast sums without formulas
Find out more ➝
Excel
Turn numbers into money with one click
Find out more ➝
Excel
Save time adding new columns or rows
Find out more ➝
Excel
Create ranges of data without doing any typing
Find out more ➝
Excel
Swap rows into columns and vice versa
Find out more ➝
Excel
Make dull data stand out and become dynamic
Find out more ➝
Excel
Insert live Excel data into Word
Find out more ➝
Excel
Make a drop-down list to select from
Find out more ➝
Excel
Understand your data with super-fast graphs
Find out more ➝
Excel
Combine text from two cells into one
Find out more ➝
View more