How To Paste Transpose In Excel 9 Simple Steps

Another option is to click one of the cells in the desired range, then hit ⌘ Command+A (on a Mac) or Ctrl+A (in Windows) to select the entire range.

Make sure you use the Copy command rather than the Cut command. Otherwise, you won’t be able to paste your data.

For instance, if you’re moving data from the row A:1-C:1, try clicking on E:2 to start your new column.

Alternatively, right-click the top left portion of the cell where you want to paste your data to open a context menu. [5] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source Or, if you’re on a Mac, ^ Control-click on the cell instead.

Depending on which version of Excel you’re using, you may see the Transpose option as an icon that looks like a clipboard with 2 perpendicular blue and white rectangles connected by a curved arrow. [7] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source

Add a dollar sign before the column and row references in each formula. For instance, if a cell contains the formula =A2+B3, change it to =$A$2+$B$3 to lock the reference and change the formula from relative to absolute. Add a dollar sign to just the row or just the column reference to create a “mixed” reference that is partially relative and partially absolute. For instance, =$A3 will lock the reference to column A, but not to row 3.

Select a range of blank cells where you’d like your data to go, making sure it’s the same number of cells as the original range. In the first cell of your new range, type =TRANSPOSE(). Insert the original data range (e. g. , A1:B6) in the parentheses. Hit Ctrl+⇧ Shift+↵ Enter. Your data, including any tables, will appear in the new range you selected.