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.

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

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 …

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 …

Insert a new column next to the cells with text. In this example, column E contains the text stored as numbers. Column F is the new column. In one of the cells of the new column, type =VALUE …

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 …

Enter the number of columns in the Number box, and the space between each column (in inches) in the Spacing box. If the Columns button is grayed out, it's likely because you are working on …

Insert a new column into the table. You can do this by typing in the column immediately to the right of the table, and Excel will automatically extend the table for you.

Note: The double line between two columns is an indicator that you've hidden a column.

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.