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

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 …

Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.

You can convert the table to a range first by using the Convert to Range button on the Table tab, or you can use the TRANSPOSE function to rotate the rows and columns.

After you create an Excel table in your worksheet, you can easily add or remove table rows and columns. You can use the Resize command in Excel to add rows and columns to a table: Click …

How to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.

Learn how to select cells, ranges, entire columns or rows, or the contents of cells, and discover how you can quickly select all data in a worksheet or Excel table.

How to lock cells in Excel to protect your data. You can also unlock a range of cells and grant permissions to others to edit.

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 …

How to hide and unhide columns and rows in an Excel worksheet. Restrict access to only the data you want to be seen or printed.