Itqualityassurance
Control + C (Windows) or Command + C (Mac) – to copy range of cells. Control + V (Windows) or Command + V (Mac) – to paste in the destination cells.
- How do I copy one row to multiple rows in Excel?
- How do I convert data from one row to multiple rows?
How do I copy one row to multiple rows in Excel?
Double-click the cell that contains the data that you want to move or copy. You can also edit and select cell data in the formula bar. Select the row or column that you want to move or copy. In the cell, click where you want to paste the characters, or double-click another cell to move or copy the data.
How do I convert data from one row to multiple rows?
Select a blank cell and right click to select 'Transpose'. The data will then be converted into multiple rows.
