My worksheet is numbered in both row and column. Is that right?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sheila - 21 Mar 2006 19:41 GMT

I'm finding it hard to create formulas with thie 2003 version of microsoft
office excell due to the fact that the row is numbered as well as the column.
Am I not doing something I should be or is this an error in my application?

Reply to this Message

Sloth - 21 Mar 2006 19:39 GMT

Tools->Options->General tab->unselect "R1C1 Reference Style"

> I'm finding it hard to create formulas with thie 2003 version of microsoft
> office excell due to the fact that the row is numbered as well as the column.
> Am I not doing something I should be or is this an error in my application?

Reply to this Message

SteveG - 21 Mar 2006 20:16 GMT

Sounds like you need to change your settings. Go to the Tools menu.
Select the Options. Select the General tab. In the settings, if th
R1C1 reference style check box is selected, de-select it. That wil
return you to lettered columns and numbered rows.

HTH

Stev

Reply to this Message