The COLUMN function returns the column number of the given cell reference. For example, the formula =COLUMN (D10) returns 4, because column D is the fourth column.

The COLUMN function returns the column number of the given cell reference. For example, the formula =COLUMN (D10) returns 4, because column D is the fourth column.

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. For …

Take text in one or more cells and split it into multiple cells using the Convert Text to Columns Wizard.

If you format a document with columns (as in some newsletter layouts), the text will automatically flow from one column to the other. You can insert your own column breaks for more control over the …

An array or array formula, or a reference to a range of cells for which you want the number of columns. Example Copy the example data in the following table, and paste it in cell A1 of a new Excel …

To insert a single column: Right-click the whole column to the right of where you want to add the new column, and then select Insert Columns. To insert multiple columns: Select the same number of …

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

In the Columns dialog box, adjust the settings under Width and spacing to choose your column width and the spacing between columns. If you want columns of varying widths, deselect the checkbox …

In Microsoft Word, you can adjust a table's size and column and row dimensions, either manually or automatically. You can also change the size of multiple columns or rows and modify the space …

To add a column to the left of the cell, select Insert Left in the Rows and Columns group. To add a column to the right of the cell, select Insert Right in the Rows and Columns group.