Home > OS >  Why Excel automatically displays have been hidden columns
Why Excel automatically displays have been hidden columns

Time:09-29

, please put forward at last is how to solve this problem, recently also appear this kind of circumstance, reshipment EXCEL can solve

I tested on multiple machines, are office2003 SP3 version, found that half of the excel is the trouble, but have been no countermeasure, do not know how to start, you might as well do a simple test: a new excel file, in the first line A1, B1, C1 respectively, fill in the 1, 2, 3 Numbers casually, then B, C two columns hidden, in D1 type=then point A1 cell, then hide the B, C two columns are automatically displayed, but when I press enter, after the two columns automatically hide again,
Half of the machine will not appear this problem, half is the above problem, I didn't find where the problem is found half a day, have devoted friends can help you?

CodePudding user response:

It is a fine thing, is not thinking of you can use to hide the two columns, very thoughtful design

CodePudding user response:

I also trapped by this problem, which master give guidance?

CodePudding user response:

Take a look at this: http://www.office68.com/excel/16487.html
There are about, below this position, if checked, it would be the effect of the building Lord said, my is traditional, simplified Chinese should be the same options,

CodePudding user response:

To learn, this is cell setting problem?

CodePudding user response:

The
reference 3 floor ZBDZJX response:
take a look at this: http://www.office68.com/excel/16487.html
There are about, below this position, if checked, it would be the effect of the building Lord said, my is traditional, simplified Chinese should be the same options,

The test as you said!
  • Related