Excel Forum
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



Mr Excel & excelisfun Trick 10: Turn Column / Row Upside Dow


See Mr Excel and excelisfun invert a range (Turn a range of cells upside down) with two different INDEX formulas. See the functions: INDEX ROW, ROWS, COLUMNS. See how to flip range 180 degrees (instead of TRANSPOSE function which only does 90 degrees.
See related videos:
Excel Magic Trick 307: Invert Range With Formula
Dueling: Invert a Range - 1015 - Learn Excel from MrExcel





Got a Question? Ask it Here in the Forum.