How to use Transpose in Excel to rotate columns and rows to rearrange your worksheet data.

Select the first cell where you want to paste the data, and on the Home tab, click the arrow next to Paste, and then click Transpose. Pick a spot in the worksheet that has enough room to paste your data.

The TRANSPOSE function must be entered as an array formula in a range that has the same number of rows and columns, respectively, as the source range has columns and rows.

Select the first cell where you want to paste the data, and on the Home tab, click the arrow next to Paste, and then click Transpose. Pick a spot in the worksheet that has enough room to paste your data.

When you use the Microsoft Excel products listed at the bottom of this article, you can use a worksheet formula to covert data that spans multiple rows and columns to a database format (columnar).

How to change the column width and row height, including how to use the AutoFit feature, in your Excel worksheet.

The Totals Row lets you pick which aggregate function to use for each column. Click the cell in the Totals Row under the column you want to adjust, then click the drop-down that appears next to the cell.

After you switch rows to columns in the chart, the columns of data are plotted on the vertical axis, and the rows of data are plotted on the horizontal axis. However, you can quickly change the way that …

Change column width or row height to make data more visible by dragging the column or row headers.

How to sort and organize your Excel data numerically, alphabetically, by priority or format, by date and time, and more.