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.

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 …

That combination of table and column names is called a structured reference. The names in structured references adjust whenever you add or remove data from the table. Structured references also …

Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.

Excel comes with multiple Lookup and Reference functions that let you find matching values. Use this article to decide which function is best for your needs.

When you paste copied data, the pasted data uses the column width settings of the target cells. To correct the column widths so that they match the source cells, follow these steps.

The R1C1 reference style is useful for computing row and column positions in macros. In the R1C1 style, Excel indicates the location of a cell with an "R" followed by a row number and a "C" followed …

You can use AutoSum to quickly sum a column or row or numbers. Select a cell next to the numbers you want to sum, select AutoSum on the Home or Formulas tab, press Enter (Windows) or Return (Mac), …

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.

Select a range of data, such as A1:L5 (multiple rows and columns) or C1:C80 (a single column). The range can include titles that you created to identify columns or rows.

Enter a formula Formulas are equations that perform calculations on values in your sheet. All formulas begin with an equal sign (=). You can create a simple formula by using constant and calculation …