You can use the Cut command or Copy command to move or copy selected cells, rows, and columns, but you can also move or copy them by using the mouse. By default, Excel displays …

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.

In Datasheet view, drag the selected columns horizontally to the position that you want. In Design view, drag the selected columns vertically to the position that you want.

To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can …

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.

Here’s how: Select the range of data you want to rearrange, including any row or column labels, and either select Copy on the Home tab, or press CONTROL+C. Note: Make sure you copy …

Learn howt to move a PivotTable so that you can insert worksheet cells, rows, or columns at the current location of the report

In Excel, you can change the layout and format of the PivotTable data to make it easier to read and scan.

Pressing an arrow key while SCROLL LOCK is on will scroll one row up or down or one column left or right. To use the arrow keys to move between cells, you must turn SCROLL LOCK off.

You can divide the contents of a cell and distribute the constituent parts into multiple adjacent cells. For example, if your worksheet contains a column Full Name, you can split that column …