Columns are Numbered rather than lettered?

F

Firman

All of my columns in my worksheets suddenly have come up with numbers rather
than the traditional letters. What went wrong and how do I correct this?
 
O

OssieMac

Hi,

Pre xl 2007 versions: Select menu item Tools->Options->General tab and
uncheck R1C1 reference style.

If using xl2007 then click the microsoft button top left of screen, select
Excel Options towards bottom right of dialog box then formulas and it is
under Working with formulas.
 

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

Grouping {MERGEFIELD} into 2 or 3 Columns 0
Keep First Letters, with exceptions 0
Possible to Combine reports to's to a single box? 0
Text missing from Publisher document. 1
Merging from an Excel file with graphics 1
Excel does not accept text format! 0
Improving Macro That Keeps First Letter 0
Keyboard Mistyping - as if a computer virus - only happens in Outlook (www.portal.office.com) 0

Top