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