Excel Forum
Similar Content
How to Add, Remove, and Rearrange Columns and Rows in Excel
Tutorial: Adding, removing and rearranging columns is as easy as resizing. You just select your colu...
Quickly Switch the Columns and Rows of a Data Set in Excel
Tutorial: How to switch a data set in Excel so that the columns become rows and the rows become col...
Quickly Resize Multiple Columns or Rows at Once in Excel
Tutorial: How to quickly resize multiple columns and rows at once in Excel.  This avoids having to...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Magic Trick 460: Transpose Range with INDEX, COLUMNS and ROWS functions


See how to transpose a range (switch rows and columns) using INDEX, COLUMNS and ROWS function. If you dont want to use TRANSPOSE function, this is a good substitute.





Got a Question? Ask it Here in the Forum.