| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to return column letters
In Excel 2007, I need to use the letters of the column that I am in in the
formula bar. However, I don't need a particular cell, just the letters. Because of this, the letters do not change as I use Autofill down the row. I am using over 500 columns, so I really need for Autofill to do this for me. Basically, in the formula bar, I have "A" in part of my formula (when I am in column A), but when I autofill, every column still has "A" rather than updating. Is there a formula that returns the column letters of the current position? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Bar blocks column header letters so I can't paste | New Users to Excel | |||
| Formula bar obscures top of column letters | Excel Discussion (Misc queries) | |||
| formula for column letters | Excel Discussion (Misc queries) | |||
| How do change a column of data in capitol letters to small letters | Excel Discussion (Misc queries) | |||
| Return column letters to spreadsheet. | Charts and Charting in Excel | |||
Threaded Mode
