How To Add Clear Button In Excel

Joshua is a graduate student at the USF. He has interests in business technology, analytics, finance, and lean six sigma.

You lot may want to clear all your work inside a worksheet instead of creating a new sheet. If this is the case, you are in the right place. This article will testify you lot how to create a button that will clear every row of a workbook excluding the first row. You'll need to keep the start row so y'all tin can keep your push button handy for its adjacent use. If you lot do non take the developer tab (the developer tab is needed in this tutorial) in Microsoft Excel observe out how to make it visible here.

Adding the Programmer Tab

Step 1: Insert a Button

Showtime, click on the developer tab and choose the insert button. From the grade control area of the drop-down, cull the push button in the showtime row to the left. The steps are indicated by 1, ii, and 3 in the illustration beneath.

Inserting a Form Control Button

Next, drag the cursor somewhere in row i to create a button. After the outline of the button is drawn the Assign Macro box appears. Click on the record button.

Pace 2: Start Recording a Macro

Side by side, the Record Macro window will appear. Name the macro and click OK. Yous can tell the macro is recording by the square stop button in the lesser left-hand corner of your screen this stop button will terminate the macro at any time during recording.

Step 3: Select Surface area to be Deleted

For this worksheet, everything below row 1 needs to be cleared when the button is pressed. Showtime by selecting row 2. At present printing Ctrl + Shift + Down arrow. This will select every row beneath row 1.

Stride four: Clear The Surface area

When all the rows are selected go to the home tab. Observe the edit group and click on clear. Next click on articulate all.

Step v: Stop Recording The Macro

Press Ctrl + home to become back to the summit of the workbook if necessary and click somewhere in the worksheet to deselect the selected cells. At present click on the stop button to the right of "gear up" in the bottom left-hand corner. At present the macro has finished recording and the button that was fatigued earlier should appear. When the button is clicked it will clear whatever formatting or text below row one.

Formatting the Button

To format the button, right-click on the button and click on Format Command.

Curlicue to Continue

When the Format Command window appears, you will be given several options. Each tab selection is listed in the table below. Make any necessary changes to format your button.


TAB	OPTION
TAB	OPTIONS
FONT	Change font type, size, style, color, and effects
ALIGNMENT	Change text alignment and text direction
SIZE	Alter top and width or scale of the box
PROTECTION	Lock options for a protected sheet
PROPERTIES	Change object positioning
MARGINS	Modify internal margin
ALT TEXT	Change text that appears on push

Closing the Workbook

When using macros in workbooks they must be saved under the file proper noun.XLSM to stand for a macros workbook. If the workbook is not saved under this file extension, the macro you created will not part at all. To save, select the File tab and so Save Equally. Select the location to save in and create a file name. Next, find Excel Macro-Enabled Workbook from the "Relieve as type" dropdown. At present save the workbook.

Additional Resource

Please see the video below titled "Creating a Macro Button to Articulate a Whole Worksheet" if y'all were unable to learn with the article.

Creating a Macro Push button to Articulate a Whole Worksheet

References

Crowder, J. (2020, Jan ane). How to Add the Programmer Tab in Excel. Retrieved January 1, 2020, from https://youtu.exist/nskuG6pK5ig.

How to Create a Macro Push to Relieve & Close an Excel Workbook
The article describes how to create a macro button on an Excel spreadsheet that will save and close a workbook to avoid having to select both operations.
How to Add the Developer Tab in MS Excel 2016
This article shows you how to navigate through the MS Excel options menu to enable visibility of the developer tab within the Excel master card.
Create a Macro Button in MS Excel 2016 to Filter Data
The article will show you how to create a set of buttons allowing you to filter a table within a spreadsheet and revert to your original view apace. A certificate template for the task will be provided.
How to Create a Button in Microsoft Excel That Opens a Figurer
Shows a Microsoft Excel user how to create a push that opens upwards the Windows pre-installed calculator application from an Excel spreadsheet.

To learn more than about developing in Excel, I recommend taking a expect at the book Microsoft Excel 2019 VBA and Macros (Business Skills) past Bill Jelen to enhance your skills.

This content is authentic and true to the all-time of the author's knowledge and is non meant to substitute for formal and individualized communication from a qualified professional person.

Joshua Crowder (writer) from Tampa, FL on Dec 02, 2019:

Thanks! I just wanted to show that everything can be deleted if you want.

Farah Kiaei on February 27, 2019:

Not bad idea that how much is important to clear every row of a workbook excluding the beginning row.