Skip to main content

Excel Tips: Edit > Copy and Paste

Paste Special

Paste as Picture

How to easily copy and pasted range or chart as picture in Excel?

How to paste a range of cells into message body as image in Excel?

Paste Transpose

How to paste transposed and keep formula reference in Excel?

How to transpose and concatenate cells into one column with delimiter in Excel?

How to transpose and link values in Excel?

How to transpose cells in one column based on unique values in another column?

How to transpose columns to rows and insert new rows to fill down data in Excel?

How to transpose data from column into one single cell in Excel?

How to transpose duplicate rows to columns in Excel?

How to transpose reference while auto fill down/right in Excel?

Transform Range

How to change row to column in Excel?

How to convert a single row to multiple columns and rows in Excel?

How to convert horizontal list to vertical list in Excel?

How to convert matrix to vector or single column in Excel?

How to convert multiple rows to columns and rows in Excel?

How to convert vector / single row or column to matrix in Excel?

How to convert vertical list to horizontal or vice versa in Excel?

How to copy horizontal paste vertical or vice versa in Excel?

How to create list from range in Excel?

How to merge two columns into one with alternating values in Excel?

How to move cells from horizontal to vertical or vice versa?

How to move data from column(s) to row(s) or vice versa in Excel?

How to move every other row to column in Excel

How to quickly stack multiple columns into one column in Excel?

How to quickly transpose address list from rows to columns in Excel?

How to quickly transpose blocks of data from rows to columns in Excel?

How to quickly transpose ranges and skip blank cells in Excel?

How to split by delimiter and transpose cells in Excel?

How to stack columns from left to right into one column in Excel?

How to transpose / convert columns and rows into single column?

How to transpose / convert columns and rows into single row?

How to transpose columns and rows when paste data in Excel?

How to transpose every 5 or n rows from one column to multiple columns?

Transpose Table Dimensions

How to convert crosstab table (2-dimensional table) to list in Excel?

How to convert flat list to 2-dimentional cross table in Excel?

How to convert matrix style table to three columns in Excel?

How to easily and quickly transpose range and stack data in Excel?

How to transpose/convert a single column to multiple columns in Excel?

Others

How to transpose and link values in Excel?

How to use shortcut keys to paste special into Excel?