Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel question. Format changed for row/column R1C1 style 1

Status
Not open for further replies.
ziggs

ziggs

Technical User
Sep 21, 2000
195
US
For an unknown reason, a format changed in an excel document I'm using occurred. The columns used to be identified by a letter. Unfortunately, it now has the column set as a number (R1C1 style). How can I change back?
Thanks
 
Sort by date Sort by votes
In TOOLS->OPTIONS, under the GENERAL tab and SETTINGS heading, there is a check box for R1C1 reference style cells. Uncheck the box, click on OK, and you should be fine!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
580
Bijugate
Bijugate
remeng
  • Locked
  • Question
Excel Pivot Table - Combine Values into a single row
Replies
16
Views
2K
remeng
remeng
grnzbra
  • Locked
  • Question
Force Data Entry Format in Excel
Replies
10
Views
393
combo
combo
Swi
  • Locked
  • Question
Excel Webservice
Replies
2
Views
393
mintjulep
M
Kennelbloke
  • Locked
  • Solved
Excel Unique-Filter issue
Replies
3
Views
310
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top