<< Click to Display Table of Contents >> Transposing cells

The ribbon command Data | group Edit | Transpose exchanges the row and column order of the selected cells. Rows become columns, and columns become rows.

Select the desired cells before you use this command.

Important: Please note that transposing does not adapt any formulas or range names to the changes made to cell addresses by transposing, neither inside nor outside the transposed range!