Quickly Clear Data Entry Cells in Excel

If you name a range of cells in Excel, you can use that name in a formula, or as the source for a data validation list, or as the data source for a pivot table.

You can also select the range, and use it to jump to specific cells when entering data, as in the Grades range, in the report card shown below.

ReportCard03

Clear Cells in a Named Range

Another good use for a named range is to quickly clear a group of cells. For example, in this order form, information is entered in the green cells.

OrderEntry01

Name those cells, and you can quickly clear them before starting the next order.

  1. Select all the green cells, and name the range DataEntry.
  2. Click the arrow at the right of the Name Box, and click on DataEntry.
    OrderEntry02
  3. With all the data entry cells selected, press the Delete key, to clear the cells

Add a Button to Clear the Cells

To make it easier to clear the cells, you could record a macro while you select and clear the named range.

Then, add a button to the worksheet,

InsertFormButton

and assign your macro to that button.

OrderEntry03

_______________

You may also like...

4 Responses

  1. Mike Bondi says:

    Thank you for the explanation of creating a macro to clear data. My form is now perfect!

  2. Gaz says:

    So what would be the VBA code for the button to clear the cells..?

  3. The easiest way to get the correct VBA code is to record a macro while you select and clear the named range.
    Then the code will be specific to your workbook and named range.

  4. Nargis says:

    um excus me plz help dis deleted evrythng

Leave a Reply

Your email address will not be published. Required fields are marked *