How to change columns to rows and vice versa
Do the following:
1. Highlight the data that you want to change in your spreadsheet:
- The column that you want to change to a row
- The row that you want to change to a column
- The data range in which you want to change columns and rows.
2. To copy selected information in the clipboard, do one of the following:
- Select Edit -> Copy
- Right-click in the selection and choose Copy in the popup menu
- Click Ctrl+C.
3. Select the cell where you want to place the changed information.
4. To paste changed information, do one of the following:
- Select Edit -> Paste Special...
- Right-click and choose Paste Special... in the popup menu.
5. In the Paste Special dialog box, check the Transpose checkbox and then click OK:
Please, disable AdBlock and reload the page to continue
Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.
