If you have a worksheet with data in columns that you need to rotate to rearrange it in rows, use the Transpose feature. With it, you can quickly switch data from columns to rows, or vice versa.

If you have a worksheet with data in columns that you want to rotate so it’s rearranged in rows, you can use the Transpose feature. It lets you rotate the data from columns to rows, or vice …

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.

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.

You can add columns, rows, or cells to an Excel worksheet or delete them. Columns insert to the left, rows above, and cells above or to the left.

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.

Copy the rows or columns that you want to transpose. Select the destination cell (the first cell of the row or column into which you want to paste your data) for the rows or columns that you are …

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

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 …

When an Excel worksheet spans more than one page, you can print row and column headings (also known as headers or labels) on every page.