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

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

Select the desired cell range 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!