Sunday, March 27, 2011

How to Add a Column Number in Microsoft Excel 2003


1. Choose a cell on your spreadsheet to display the result of your formula.
2. Click the 'Insert Formula' button next to the formula bar.
3. Select 'Lookup and Reference' from the drop-down list of function categories.
4. Select 'COLUMN' from the list of functions and click 'OK'.
5. 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.
6. Click the 'OK' button. Your cell will now display the numerical value of the column you selected.

Blogger news