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 the Paste …

Data in rows is pasted into columns and vice versa. Here's how you can transpose cell content: Copy the cell range. Select the empty cells where you want to paste the transposed data. On the Home …

In Excel, you can paste a specific aspect of the copied data like its formatting or value using the Paste Special options. After you've copied the data, press Ctrl+Alt+V, or Alt+E+S to open the Paste Special …

Insert a line break to start a new line of text or add space between lines of text in a cell in Excel.

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 versa.

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.

When you select a row or column that has formatting applied, that formatting will be transferred to a new row or column that you insert. If you don't want the formatting to be applied, you can select the Insert …

Moving formulas is very much like moving data in cells. The one thing to watch for is that the cell references used in the formula are still what you want after you move.

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.

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).