Home >Topics >excel >How to restore ABCD in Excel table

How to restore ABCD in Excel table

coldplay.xixi
coldplay.xixiOriginal
2020-12-29 13:57:2019809browse

How to restore ABCD in Excel table: first open the software and click on the tools in excel; then find the options button and click on General above; finally find the R1C1 reference style and set it.

How to restore ABCD in Excel table

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

How to restore ABCD from Excel table:

1. Open the excel software in our computer and go directly to the software page

How to restore ABCD in Excel table

2. We see that our rows and columns are not displayed normally

How to restore ABCD in Excel table

3. This is the correct display method, so how do we modify it? Come here

How to restore ABCD in Excel table

#4. We click on the tool in excel and find the option button below

How to restore ABCD in Excel table

5. Pop-up In a dialog box, we click on General above, as shown in the figure

How to restore ABCD in Excel table

6. When we see the R1C1 reference style, we set it up

How to restore ABCD in Excel table

7. Finally we see it, it has been set up, back to the way we were before, as shown in the picture

How to restore ABCD in Excel table

Related learning recommendations: excel tutorial

The above is the detailed content of How to restore ABCD in Excel table. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn