Mar 25 2022 08:50 AM
Mar 25 2022 09:17 AM
Do you mean that you want to get rid of the drop-down in cell E9?
If so: select E9, then click Data Validation on the Data tab of the ribbon.
Click Clear All, then click OK.
You'll have to click out of the cell then back to see the result.
Mar 25 2022 09:19 AM
Mar 25 2022 09:47 AM
Activate the Developer tab of the ribbon.
In the Controls group, click to highlight Design Mode.
You should see a combo box appear somewhere on the sheet.
Right-click on it and select Properties from the context menu.
Scroll down the list of properties if necessary, until you see Style in the left-hand column.
Change the value in the right-hand column to 2 - fmStyleDropDownList.
Close the Properties pane, then click to unhighlight Design Mode.
Save the workbook.