View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default sometimes comfortable with the previous notation for region(eg.A1:B3)

Office Button (top left)Excel OptionsFormulas, uncheck R1C1 reference style

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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