'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Remove an Embedded Form Control in Excel
Question details
The user needs to delete an embedded HTML drop-down control (e.g., Forms.HTML:Select.1) that appeared after pasting data from a website.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Copying and pasting data containing web elements from a web page directly into an Excel spreadsheet.
- Observed behavior
- An unclickable or undeletable HTML form control object is embedded in the sheet, and standard deletion or data validation methods do not work.
Ensure you have saved your current workbook before modifying ribbon settings or deleting objects to prevent any accidental data loss.
Use Design Mode in the Developer Tab
Activating Design Mode allows you to select and interact with developer objects and embedded HTML controls so you can delete them.
Web elements copied into Excel are often treated as ActiveX or Developer controls. Standard selection methods ignore them, requiring you to activate Design Mode to modify or delete them.
Go to File > Options > Customize Ribbon. Check the 'Developer' box in the right column and click OK.
Navigate to the newly added Developer tab on the Excel ribbon and click on 'Design Mode'.
Click directly on the stubborn embedded HTML control (such as Forms.HTML:Select.1 or Forms.HTML:Text.1) to select it, then press the Delete key on your keyboard.
Use the Selection Pane
If the control is difficult to click or hidden, the Selection Pane lists all objects on the sheet for easy deletion.
Easily Manage Objects and Controls with WPS Office
WPS Spreadsheet offers a highly compatible and intuitive interface, making it simple to manage inserted objects, web controls, and macros without hassle.
- 1. Open your file: Launch WPS Spreadsheet and open the document containing the web controls.
- 2. Access Developer tools: Navigate to the Developer tab on the top ribbon.
- 3. Enable Design Mode: Click 'Design Mode' to make developer objects selectable.
- 4. Delete the control: Click on the embedded web form control and press the Delete key.
Frequently Asked Questions
Why did an HTML control appear in my Excel sheet?
When you copy data from a website and paste it directly into Excel, web elements like drop-down menus or text boxes (Forms.HTML:Select.1) are sometimes carried over as embedded objects along with the text.
Why can't I delete the form control normally?
These controls are treated as developer objects rather than standard shapes or text. Because they are interactive, you must enter Design Mode to make them selectable for editing or deletion.
How do I prevent web controls from pasting into Excel?
Instead of a standard paste (Ctrl+V), right-click the destination cell and choose 'Match Destination Formatting', or use 'Paste Special' > 'Text' to paste only the raw data without the HTML elements.
