Select the destination cell (the first cell of the row or column into which you want to paste your data) for the rows or columns that you are transposing. Excel makes space for the new row or column.Ĭonvert columns to rows, or rows to columnsĬopy the rows or columns that you want to transpose. Hold down SHIFT and drag your row or column between existing rows or columns. Move or copy data between existing rows or columns Hold down OPTION and drag the rows or columns to another location. When the pointer becomes a, do one of the following:ĭrag the rows or columns to another location. Point to the border of the cell or range that you selected. Select the rows or columns that you want to move or copy.
Instead of using a relative cell reference, you can make it absolute by adding a $ symbol in front of the column or row that you want to keep the same, no matter where you copy the formula too. Let's say you don't want Excel to automatically change your formula.
Cell references in formulas will update normally. To fill down into more than one cell at once, make a selection that includes multiple rows below. Hover your mouse cursor over the bottom-right corner of the cell so the cursor turns to a crosshair, then drag the crosshair down to copy the formula to other cells in the column. This shortcut copied data from the cells above to cells below, without having to copy and paste.
Excel will stop filling out the column if it sees an empty cell.