# How to Convert Columns to Rows in Microsoft Excel

> To convert columns to rows in Microsoft Excel, highlight the desired columns, copy them using right-click or Ctrl + C, select the target cell, and use the Transpose icon under Paste Options to paste the data as rows.

Canonical: https://livedemo.ai/tutorials/how-to-convert-columns-to-rows-in-microsoft-excel/
Apps: Microsoft, Excel
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a35acab56e05a00fda183/preview?step=1

## Steps

1. Highlight the column(s) you want to convert to rows.
2. Right-click and select Copy , or press Ctrl + C .
3. Click on the cell where you want to paste the data as rows, right-click, and under Paste Options, select the Transpose icon (a clipboard with a rotating arrow).
4. Your column data will now be converted to rows!