change row labels; r1c1 to a1

  • Thread starter Thread starter bob hawkins
  • Start date Start date
B

bob hawkins

somehow i've changed my lables--row, column--from a12, b10, etc--to r1c5,
r2c7, etc

how do i change back?

thanks,

bob
dallas
 
Bob

Tools>Options>General. uncheck "R1C1 reference style".

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Loop Macros 3
How to change rows, columns to alpha numerical 2
Column tags no longer letters?! 3
Alpha sorting (with a twist...?) 3
A different R1C1 vs a1 question 2
r1c1 reference style - how to make it default 4
Excel Help to copy information from one row at a time to another sheet 1
Adding formulas to rows using a Loop Macro 2

Back
Top