What should I do if the excel drop-down menu cannot be displayed? How to recover if the excel drop-down menu cannot be displayed?

What should I do if the excel drop-down menu cannot be displayed? Excel drop-down menus can help users perform operations quickly. Many functions are also here. However, many users say that their drop-down menus cannot be displayed. So what is going on? Let this site introduce to users in detail how to recover the excel drop-down menu that cannot be displayed. The excel drop-down menu cannot be displayed. Recovery method 1. First, click the file button in the upper left corner.

2. Find the option function at the bottom of the file.

3. Then open the advanced options page.

4. Find the location as shown in the picture, and check "Show All" for objects.

5. Re-open the document and you will find that it can be displayed.

The above is the detailed content of What should I do if the excel drop-down menu cannot be displayed? How to recover if the excel drop-down menu cannot be displayed?. For more information, please follow other related articles on the PHP Chinese website!