Shulou(Shulou.com)11/24 Report--

Excel is used more and more frequently in our work, and its status is becoming more and more important!

But when we usually operate Excel, sometimes there will be some strange phenomena.

This makes Xiaobai at a loss, thinking that their computer or Excel is infected by a virus! Only to scare yourself!

Come and have a look. Have these strange things happened to you?

After opening the form, there are brothers, for example, there is a file on the computer desktop: summary of sales income.

Normally, after opening the form, only one table window appears in the taskbar of the computer. As shown below:

Under abnormal circumstances, two identical table file windows appear when you open it.

What on earth is going on?

Does Excel have a brother?

This scared the baby to death!

So what's the reason?

The reasons for 👉 are:

Sometimes we need to compare two different worksheets in the same workbook. For convenience, we will create a new workbook window for comparison.

After the comparison, click the Save button directly. Finally, close the two windows.

The next time you open it, two Excel table windows will appear in the taskbar at the same time!

Of course, if you have created more than N new windows, click "Save" before closing each window, and reopen the form will show the same number of Excel windows in the taskbar!

So, how to solve this problem?

The method is also very simple, that is, close the extra windows in turn, and click the Save button when there is only the last window left.

02. There is no data after opening the form-under normal circumstances, after opening the Excel table, it is as follows:

The contents of the table and the row number and column label are all displayed.

However, sometimes when you double-click the mouse to open the file, it looks like this:

Oh, my God! Where is the form I made?

The reasons for 👉 are:

When we open a lot of workbooks, sometimes we don't want to close a workbook, so we choose to hide it temporarily.

So click the [View] = "[hide] button. The workbook is temporarily invisible!

It becomes an interface like this.

Then after we click Save and close the workbook, the situation above will appear the next time we open it!

How to solve?

Of course, click [View] = "[unhide]!

This will restore the previous interface!

03. There is no data after opening the form. Second, sometimes, after we open the Excel table, the situation will be as follows:

The contents of the table and the row number column label are not displayed.

It's just that there's a triangle button on the upper left.

What the heck is this?

The data is gone?

The reasons for 👉 are:

The rows and columns of the worksheet are hidden.

You can take a closer look at this little triangle.

If there is this small triangle, it means that the rows and rows of the table are hidden!

We can unhide the rows and rows to show the data!

Solution:

Select the small triangle first, and then the small triangle will change from [gray] to [green].

Then click [start] = "[cell] =" [format] = "[hide and unhide] =" [unhide rows] and [unhide columns].

In the end, in many cases, these strange phenomena in Excel tables are caused by unintentional or intentional human manipulation. If you meet again in the future, don't scare yourself!

Remember to collect this article, really encounter problems can also be timely inquiry, to find a solution ~

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: Spiegel Zaixin Editor: Zhu Lan

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.