Incremental method to change the cells ID (Name)

Question

I'm trying to setup an excel sheet with different columns and in every column I need the single cells to have a specific ID so I can reach to those by code, the simpler one was to put for ex. "column name1" and incremental from there, do you know a method to make something like that instead of changing all the cells ID by hand? enter image description here

Like this one for example, but intead of having 'feature1' 'feature2' ecc written as text I need those in the cells IDs/Names

EDIT
example of table Here I want to use a formula to automatically change the name of the table from "A26" to "step1", I tried to use command ="step"&ROW(A26) but this only change the text of the cell instead of the name

Answer 1

Although I have shared above what ROW Function, does, still for a proper explanation I am sharing here

The ROW function returns the row number for a reference.

In our query, ROW(J26) returns 26, since J26 is the twenty sixth row of the column J in the spreadsheet. When no reference is provided, ROW returns the row number of the cell which contains the formula. So in the above query ROW() returns 26 which on subtracting with 25 shall give us 1 which is required.

ROW function takes just one argument, called reference, which may be empty, a cell reference, or a range.

So the formula used in cell J26

=J$25&ROW()-25

And Fill Down and for the rest just press CTRL R and fill down!