---
title: Rotating Excel sheets - How to switch rows and columns
description: The Excel function 'Transpose' allows you to switch rows and columns to rotate your charts and data tables. We show you step by step how it works!
---

[empower® Blog: We love Microsoft 365 ](https://www.empowersuite.com/en/blog)

# [Rotating Excel sheets - How to switch rows and columns](https://www.empowersuite.com/en/blog/rotate-excel-charts)

 Written by [Tobias Kablitz](https://www.empowersuite.com/en/blog/author/tobias-kablitz) | August 4, 2015

The Excel function "Transpose" makes switching lines and columns easier and faster than moving the cells one by one:

1. Select the table you want to rotate.
2. Right-click to open the context menu and select "*Copy*". Alternatively, you can press "*Ctrl + C*".
3. Select the cell that you want to be in the upper left corner of the rotated chart.
4. Right-click again to open the context menu and select the fourth icon (rotated rectangle) under "*Paste options*".
5. Result: Your table will be inserted along with its formatting settings, with the previous columns showing as rows and vice versa.

 

Are you looking for a tool that helps you and your employees manage Excel more easily? Read up on empower® Sheets, an add-in for Excel that provides you with great tools to [improve your efficiency in Excel](https://www.empowersuite.com/en/products/empower-sheets), all while adhering to the company design.

[View full post](https://www.empowersuite.com/en/blog/rotate-excel-charts)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Tobias Kablitz"
  },
  "dateModified" : "2023-04-20T15:59:47.575Z",
  "datePublished" : "2015-08-04T22:00:00Z",
  "headline" : "Rotating Excel sheets - How to switch rows and columns",
  "image" : {
    "@type" : "ImageObject",
    "height" : 314,
    "url" : "https://www.empowersuite.com/hubfs/Marketing/Blog/Feature/turn-excel-charts-switch-columns-cells-feature.webp",
    "width" : 600
  },
  "mainEntityOfPage" : "https://www.empowersuite.com/en/blog/rotate-excel-charts",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60,
      "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
      "width" : 60
    },
    "name" : "empower® Blog"
  }
}
```