Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

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

Cell reference style "stuck" on relative

Status
Not open for further replies.
SoledWorker

SoledWorker

Mechanical
Aug 20, 2001
50
I fired up excel and found that all of my spreadsheets are showing numbers in the column labels (as opposed to letters) and formulas are now showing in R1C1 style. I couldn't find the setting to change this back, and help was now help. HELP! Anybody know what happened and how to fix it?
 
Replies continue below

Recommended for you

Sort by date Sort by votes
Take a deep breath and try Tools->Options->General->R1C1 reference style
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dik
  • Locked
  • Question
Convert Cell Types 1
Replies
10
Views
420
dik
dik
dik
  • Locked
  • Question
Copying Cells 2
Replies
6
Views
451
dik
dik
electricpete
  • Locked
  • Question
an update to vba routine for highlighting the current cell 3
Replies
6
Views
134
skeletron
skeletron
bacon4life
  • Locked
  • Question
Bottom align the text in a cell with wrap text turned on?
Replies
3
Views
335
bacon4life
bacon4life
Histor
  • Locked
  • Question
Autogenerate Typical Rows based on input value
Replies
4
Views
105
SkipVought
SkipVought

Part and Inventory Search

Sponsor

Back
Top Bottom