|I'm not sure what you mean by "change 2R To 1R" but if you are having trouble selecting a single cell, the solution in the following thread might help.|
"This is a known issue with Excel 2007 and later. Adjusting the zoom level up then down then back to the required setting is reported to clear it."
DAGS and you'll see that many others have experienced it.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.