How Can I solve the strange problem with my EXCEL?

H

Haoyu Zhang

Dear Friends,
The column number of my excel is also 1, 2, 3, 4, ... which
is very strange and I can't use formula. It looks like

|1|2|3|4|
----------
1| | | | |
----------
2| | | | |
----------
3| | | | |
----------

In stead of like

|A|B|C|D|
----------
1| | | | |
----------
2| | | | |
----------
3| | | | |
----------

I have tried a lot but I can't find the way to solve it.

Thanks a lot for your kind help.

Best,
Haoyu
 
D

DavidR

Go to "Tools" then "Options" then click the "General" tab. Uncheck the R1C1
reference box.
 

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

List all tables, including document structure 0
how to solve the following in excel 1
Outlook 2010 can't find .pst file 1
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Staggered filter on Excel 0
Very strange behaviour of VLOOKUP in Excel 2010 4
Vlookup or similar 7

Top