How to Remove a Drop Down Box in Excel 2003

104 23
    • 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.

"Technology" MOST POPULAR

How to Reset Word 2007 to Default

libxclass0

LI

How to Create a Book in Indesign

gnomermind

What Is MS Office Word?