Changing Row Numbers

J

Jennifer

I have Titles/Names in Columns A through M

How do I make the Row numbering start after the words i have typed? Or can
i Change the Column alphabets to custom words. (EX: change the A,B,C,D to
words of my choice.)

I am trying to make a Student Role for my class. I need cell A1 to start
after my titles.

Thanks, hope i explained it ok.
 
P

Peo Sjoblom

No you can't, you can choose not to display any of the built in row/column
headers (tools>options>view) and then roll your own

--
Regards,

Peo Sjoblom

(No private emails please)
 
G

Gord Dibben

Jennifer

You cannot change the Column letters or the row numbers.

You can give the appearance of such by........

Typing your titles in row 1, columns A through M.

Go to Tools>Options>View and uncheck row and column headers.

In A2 enter =Row()-1 to re-number the rows.

Select B2 and Window>Freeze Panes to keep row 1 and Column A in view.

Note: Any formulas will have to be adjusted.

A1 is still A1 and A2 is still A2 etc.


Gord Dibben Excel MVP
 
Top