The "COLUMN" function in Microsoft Excel 2003 allows you to use the column number in equations, calculations and formulas without creating a series of labels on your spreadsheet that explicitly number the columns. You can use the "COLUMN" function to quickly create numerical labels across the top of a spreadsheet or find a column's value when making a calculation. The "COLUMN" function works with or without a reference argument, but if you want the value of a column other than the one for the cell containing the formula, you must provide a reference.
Things You'll Need
- Microsoft Excel 2003
Choose a cell on your spreadsheet to display the result of your formula.
Click the "Insert Formula" button next to the formula bar.
Select "Lookup and Reference" from the drop-down list of function categories.
Select "COLUMN" from the list of functions and click "OK".
Provide a reference for the "COLUMN" formula to use. If you want to use the cell you selected in Step 1, do not enter a reference; if you want to use a different cell, enter that cell's coordinates in the reference box.
Click the "OK" button. Your cell will now display the numerical value of the column you selected.
Tips & Warnings
- Typing "=COLUMN()" into a cell is an advanced way of using the "COLUMN" function without references. If you need to reference another cell, put the reference in between the parentheses.
- You can use the "COLUMN" function as a reference in most of Excel's mathematical functions. Excel will use the value the function returns like a numerical argument.
- If you provide an incorrect argument for the reference, Excel will show you an error.
How to Add Columns to a Microsoft Word Document
You can add columns to a Microsoft Word 97 and 2000 (for PC) and 98 (for Macintosh) document to give it a...
How to Sum a Column in an Excel Spread Sheet
Many complex tables or spreadsheets that you may create are based on the basic principle of summing a column or row of...
How to Find the Last Number in a Column Using Excel
Microsoft Excel is a spreadsheet application that enables you to sort and classify massive amounts of data. Because of the large amount...
How to Add a Counter in Microsoft Excel
It is important to have as much information as you can about the data with which you are working when creating a...
How to Sum a Column or Row of Excel Cells
Sum columns or rows in an Excel spreadsheet by highlighting the row or column and clicking auto sum. Add columns or rows...
How Do I Sort by Phone Numbers on an Excel Spreadsheet?
Excel is the spreadsheet component of the Microsoft Office Desktop Productivity Suite. While commonly used for mathematical analysis of data, you can...