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!