excal is protected, in excal

Make no mistake, here is beauty also.

The result is false, which means TA professor.

It's just a comparison of characters, and it has nothing to do with reality.

Assistant Zhu Jiaojiao

z>j

excel sheet protection password crack.

Method:1 Open the file.

2 Tool --- macro --- record a new macro --- enter a name such as: aa3 stop recording (this gives an empty macro).

4 Tool --- Macro--- Macro, select AA, click the button5 Delete all characters in the window (only a few), and replace them with the following: (Copy it)6 Close the window.

7 Macro --- Macro --- Macro, select allinternalpasswords, run, OK twice, wait 2 minutes, and then OK. OK, no more passwords!

Method 1: First mark the one greater than or equal to 80 in conditional formatting, and then annotate it with annotations: Level 1.

Method 2: Use filtering, automatic filtering, and create another worksheet with the filtered results, you can also create another cell named one level directly on this table.

Set it in conditional formatting.

Conditional—Conditional formatting.

Use the "if" formula, for example: if(a1<85,"Level 1","Level 2")

Is your level 1 or level 2 displayed in a grid greater than 85? Or is it in a different compartment?

You can implement this display with an if statement or conditional formatting, depending on how you design it.

if statement.

Formula =if(a2>85,"Level 1","Level 2"85 Level 2.

86 levels.

81 Level 2.

66 Second Degree.

83 Second Grade.

84 Level 2.

27 Level 2.

56 Second Level.

81 Level 2.

89 Level 1.

Level 90.

You can use the if function.

Such as: if(a1>85,"Level 1","Level 2"), then when cell A1 is greater than 85, one level is returned.

This ,,, that ,,, this question, Nasa, can you ask the specific point, no, it's really not good, you open excel and press F1

Right-click on the cell and change the cell to text format.

Use 00 1 or put. Turn white.

Format cells as text.

Add single quotation marks before re-entering.

Right-click on the far left of the sixth row, and the entire sixth row will be selected, and then click Cut. Right-click to the far left of the third row and click "Paste Cut Cell".

Insert a line on the second line, select the sixth line to cut, and paste it into the third line.

It's a very simple operation, the key is how many zeros you want to add, how to add zeros?

What data to add, let's make it clear.