The TRANSPOSE function returns a vertical range of cells as a horizontal range, or vice versa. 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.
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 worksheet rows and columns are plotted in the chart by switching rows to columns or vice versa.
When you copy in Excel for the web, you can pick paste options in the destination cells. Select Home, select the clipboard icon, select Paste, and pick the specific paste option you want.
On the Home tab, select Copy . Select the first cell in the area where you want to paste what you copied. On the Home tab, select the arrow next to Paste, and then do any of the following. The options on the Paste menu will depend on the type of data in the selected cells:
Learn how to format your data in Excel so that you can use Copilot to get insights, generate formulas for new columns, and highlight, sort, and filter your data.
