FORMATTING

  • Thread starter Thread starter DISH
  • Start date Start date
D

DISH

CURRENTLY MY SPREADSHEET HAVE NUMBERS FOR THE ROWS AND
COLUMNS, EXAMPLE CELLS ARE NOW C4R3 INSTEAD OF CELL D3.
HOW CAN I CHANGE TO FORMAT OF MY COLUMNS BACK TO LETTERS?
 
Hi
goto Tools - Options - General. and uncheck R1C1 reference style
Frank
P.S.: please turn-off your CAPS lock as it's difficult to read and
considered rude (shouting) in newsgroups
 
Tools | Options | General tab | Settings section | deselect R1C1 reference
style

Please don't type in capitals ... it's very difficult to read and is seen as
SHOUTING in the news groups.

Regards

Trevor
 
Dish,

First, turn off your CAPS lock key. Typing in all caps is
considered rude and hard to read.

Go to the Tools menu, choose Options, then the General tab.
There, uncheck the "R1C1 reference style" setting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top