Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell name
I'd like to insert the cell name (found in the upper left-hand corner of the
sheet) into each cell automatically. For instance, I have an F row, and I'd like for each cell to say the column letter + row number. How can I do this? Thankks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell name
Use:
=SUBSTITUTE((LEFT(ADDRESS(1,COLUMN()),3)),"$","") & ROW() -- Gary''s Student - gsnu200766 "excelnewbie" wrote: I'd like to insert the cell name (found in the upper left-hand corner of the sheet) into each cell automatically. For instance, I have an F row, and I'd like for each cell to say the column letter + row number. How can I do this? Thankks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell name
Hi,
Put this in F1 and drag down =ADDRESS(ROW(),6,4) Mike "excelnewbie" wrote: I'd like to insert the cell name (found in the upper left-hand corner of the sheet) into each cell automatically. For instance, I have an F row, and I'd like for each cell to say the column letter + row number. How can I do this? Thankks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell name
you may want to drag across so change to this
=ADDRESS(ROW(),COLUMN(),4) Mike "excelnewbie" wrote: I'd like to insert the cell name (found in the upper left-hand corner of the sheet) into each cell automatically. For instance, I have an F row, and I'd like for each cell to say the column letter + row number. How can I do this? Thankks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I copy a value from a cell and paste it into another cell while adding it to the previous value in that cell | Excel Worksheet Functions | |||
How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
Inputting cell value from source cell based on value in adjacent cell. | Excel Discussion (Misc queries) | |||
cell data not validated if navigating cell to cell with mouse | Excel Worksheet Functions | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) |