Steps to freeze rows and columns together in Excel Select the cell below the row you wish to freeze and next to the column you want to freeze. For example, to freeze row 1 and column A, you need ...

On the tab in the Data group, click the Switch Row / Column button. The rows are switch to columns. We hope this tutorial helps you understand how to switch rows and columns in an Excel Chart.