Applies To
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web

The TRANSPOSE function switch or rotate cells from vertical to horizontal and vice versa. 

  1. Select the top-left cell of the target output range. 

  2. Enter =TRANSPOSE(array), where array is the original range of cells that you want to transpose. For example: =TRANSPOSE(A1:C25). 

See more about the TRANSPOSE function.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.