sometimes comfortable with the previous notation for region(eg.A1:B3)

K

kang

sometimes I'm comfortable with the previous notation for
region(eg.A1:B3) instead of [#this row],[column name].
how to change the way of notation?
thanks.
 
B

Bob Phillips

What is the question relating to Excel/VBA?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
N

Niek Otten

Office Button (top left)>Excel Options>Formulas, uncheck R1C1 reference style

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| sometimes I'm comfortable with the previous notation for
| region(eg.A1:B3) instead of [#this row],[column name].
| how to change the way of notation?
| thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Column misalignment 0
Converting RIC1 code to letter Column/Numeric Row 5
Searching alfanumaric cell contents and returning with a numaric v 21
Powerpoint 2003 file notation field 7
Charts/years 0
Excel is converting my alphanumeric text to scientific notation 2
Comment Notations 4
Keeping a cell or value constant in further equations 1

Top