What should I do if the formatting of cells in Excel does not respond?

The solution to the problem that excel does not respond when formatting cells: First open the Excel document to be processed; then click the "Protect Worksheet" option under the "Review" option; then uncheck "Format Cells" ;Finally save the settings, right-click the cell and click the "Format Cells" option.

The operating environment of this article: Windows7 system, Dell G3 computer, Microsoft Office Excel2010.

The reason for this problem is: worksheet protection is set.

The solution and detailed steps are as follows:

1. First, open the Excel document to be processed, as shown in the figure below.

#2. Secondly, click the “Protect Sheet” option under the “Review” option, as shown in the figure below.

#3. Next, uncheck "Format cells", as shown in the figure below. (Recommended: "Excel Tutorial")

4. Then, save the settings, right-click the cell, and click the "Format Cells" option ,As shown below.

#5. Finally, you can see the "Format Cells" dialog box popping up, as shown in the figure below. In this way, the above problems are solved.

The above is the detailed content of What should I do if the formatting of cells in Excel does not respond?. For more information, please follow other related articles on the PHP Chinese website!