Bulk Cell Name Change

[Skip_General]

Is there a way to bulk rename cells?

In my example, you'll see the following cells have been renamed:

A2 = FN_1
B2 = LN_1
C2 = AD_1
D2 = ST_1
E2 = PC_1
F2 = CN_1

I would like to carry that down the respective columns:

A3 = FN_2
A4 = FN_3
A5 = FN_4
etc.

Is there a way to do this without having to rename every cell individually?

My actual spreadsheet has over 90 columns. I already have the first row renamed for each column.

If there is a way to rename them in bulk, that would save me an enormous amount of time.

[Sam Capricci]

you could put this in A3 and drag down...
=LEFT($A$2,3)&ROW(A2)
assumes that in A2 is FN_1

[Skip_General]

I'm not looking to increment cell values. I'm wanting to rename the cells. (see attachment)

[Sam Capricci]

Sorry, can't think of a way to accomplish that, I'll be interested to see what others offer.

[rorya]

Insert a column before column B.
In the new B1 enter FN_1
Fill that down (the 1 should increment) for as many rows as you want
Select A2:Bnn (where nn is the number of rows you filled)
On the formulas tab, in the Define Names group, choose the 'Create from Selection' button and specify Right column only.
Delete the added column B.
Repeat for the other columns.

As a general note, this sounds like a really bad idea and I suspect you'd be better off with one defined name for each column.

[Skip_General]

Hey Rorya! Thanks again for the help yesterday. Looks like you're becoming my personal excel tutor.

That idea should work. I tried something similar to that, but I was trying to use the top row and a created left column. Didn't go well.

Essentially, each cell in the row corresponds to a cell in a form. I will be using a macro with a button to fill the data from the sheet into the premade form.