Solution: First open the excel table that needs to be operated, click the "office" icon button at the top of the page; then select "excel options", select "advanced" in the pop-up window; finally check "Display Paste the box in front of the "Option Button (S)" and click the "OK" button.

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2007 version, Dell G3 computer.

Click the office button

Click Excel options

Click "Advanced" in Excel options , find the "Show Paste Options Button (S)"

Check "Show Paste Options Button (S)" and click OK, there will be auto-fill options

Related learning recommendations: excel tutorial

The above is the detailed content of What should I do if the form drop-down autofill option is no longer available?. For more information, please follow other related articles on the PHP Chinese website!