How to Remove a Drop Down Box in Excel 2003

104 24
    • 1). Click inside the cell from which you want to remove the drop-down list box. Do not double-click, as this will take you into the cell editing mode; just use a single left click.

    • 2). Select the "Data" menu from the top menu bar, and then click the "Validation" option in the menu that opens.

    • 3). Click the "Settings" tab in the data validation dialog box.

    • 4). Click "Clear all" and then select "OK". Your drop-down list will be deleted.

Subscribe to our newsletter
Sign up here to get the latest news, updates and special offers delivered directly to your inbox.
You can unsubscribe at any time

Leave A Reply

Your email address will not be published.