Changing Row Numbers
 

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.

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

--
Regards,

Peo Sjoblom

(No private emails please)


"Jennifer" wrote in message
...
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.

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 ToolsOptionsView and uncheck row and column headers.

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

Select B2 and WindowFreeze 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

On Sun, 7 Aug 2005 08:06:02 -0700, "Jennifer"
wrote:

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.