VBA & Macro Problems

Fix Excel Drop-Down List Appending Values Instead of Replacing

Ayan Masood Oct 10, 2026 869 views

Question details

Selecting a new item from an Excel drop-down list adds the new text to the existing cell content instead of overwriting it.

Fix Excel Drop-Down List Appending Values Instead of Replacing

Product: Microsoft Excel
Device & OS: not provided
Scenario: A user is trying to select a single name from a data validation drop-down list to update a cell's value.
Observed behavior: Each newly selected name from the drop-down is appended after the previous selection, combining multiple values in the same cell rather than replacing the current value.

Before you start

Since this behavior is almost always caused by a background script, ensure the Developer tab is enabled in your ribbon so you can inspect active VBA macros. Save a backup copy of your workbook before modifying any underlying code.

Solution 1Recommended

Disable or Modify the Multi-Select VBA Macro

The most common cause for drop-down values appending rather than replacing is an active VBA macro designed to enable "multi-select" functionality for that worksheet.

By default, Excel and spreadsheet applications will always overwrite cell contents when a new item is picked from a data validation list. If values are concatenating (e.g., 'Name1, Name2'), a Worksheet_Change event in VBA is overriding the default behavior.

Open the VBA Editor

Press Alt + F11 on your keyboard to open the Microsoft Visual Basic for Applications window.

Locate the Worksheet Code

In the Project Explorer pane on the left, double-click the specific worksheet containing the problematic drop-down list (e.g., Sheet1).

Find the Worksheet_Change Event

Look for a subroutine named 'Private Sub Worksheet_Change(ByVal Target As Range)'. Inside this code block, check for logic that concatenates 'Target.Value' with the old value.

Remove or Comment Out the Code

To restore standard drop-down behavior, delete the multi-select code block. Alternatively, comment it out by adding an apostrophe (') at the beginning of each line.

Save and Test

Close the VBA editor and try selecting an item from your drop-down list again. It should now replace the existing value normally.

Disable or Modify the Multi-Select VBA Macro

Macro Security Check: If you cannot find the code but the issue persists, the macro might be stored in an active Add-in. You can temporarily disable add-ins via File > Options > Add-ins to check if an external tool is causing the behavior.

Solution 2

Test with a Clean Data Validation List

Verify if the issue is isolated to a specific cell's configuration by creating a fresh drop-down list in a new worksheet.

Manage Spreadsheets with WPS Office

Create Reliable Drop-Down Lists with WPS Spreadsheet

WPS Spreadsheet provides intuitive data validation tools that default to standard, replacing drop-down behavior. Manage your data accurately without interference from hidden macros, all within a familiar, high-performance interface.

1. Open Your File in WPS: Launch WPS Spreadsheet and open your existing workbook.
2. Select the Target Cell: Highlight the cell or range where you want your clean drop-down list to appear.
3. Apply Data Validation: Go to the Data tab, select Validation, and choose 'List' from the criteria menu to establish standard replacement behavior.

Completely free to use for everyday data managementFully compatible with Microsoft Excel formats (.xlsx, .xlsm)Intuitive Data Validation tools for clean, accurate entriesBuilt-in macro controls to easily enable or disable custom scripts

microsoft office alternative - wps office

Frequently Asked Questions

Why would someone want an Excel drop-down to append values?

Appending values allows users to select multiple items from a single drop-down list (known as multi-select). This is often used for assigning multiple categories, tags, or names to one cell without needing multiple columns.

Can I have a multi-select drop-down without using VBA macros?

Native spreadsheet software, including Microsoft Excel and WPS Spreadsheet, does not support multi-select drop-down lists by default. Standard data validation will always replace the cell's contents unless modified by a VBA script.

How do I turn off all macros to test my drop-down lists?

Navigate to the Developer tab, click on Macro Security, and select 'Disable all macros without notification'. Restart your spreadsheet application and test the drop-down. If the appending stops, a macro was definitely causing the issue.

Excel & Data Problems