Press CTRL+Z if you don't want to replace a row or column.Ĭut and insert Hold down SHIFT while you point to the border of the selection. When the pointer becomes a copy pointer, drag the rows or columns to another location. Excel doesn't warn you if you are going to replace a column. Press Cancel to avoid replacing.Ĭopy and replace Hold down CTRL while you point to the border of the selection.

Excel warns you if you are going to replace a column.

When the pointer becomes a move pointer, drag the rows or columns to another location. Select the row or column that you want to move or copy.Ĭut and replace Point to the border of the selection. If you want to rotate your data frequently to view it from different angles, consider creating a PivotTable so that you can quickly pivot your data by dragging fields from the Rows area to the Columns area (or vice versa) in the PivotTable Field List.By default, drag-and-drop editing is turned on so that you can use the mouse to move and copy cells. Verify these formulas use absolute references-if they don’t, you can switch between relative, absolute, and mixed references before you rotate the data. If your data includes formulas, Excel automatically updates them to match the new placement. Īfter rotating the data successfully, you can delete the original table and the data in the new table will remain intact. Right-click over the top-left cell of where you want to paste the transposed table, then choose Transpose. The new table that you paste there will entirely overwrite any data / formatting that’s already there. Note: Ensure that you copy the data to do this, since using the Cut command or Ctrl+X won’t work.Ĭhoose a new location in the worksheet where you want to paste the transposed table, ensuring that there is plenty of room to paste your data.

Excel convert column to row