In the sections below, learn how to add a macro to a button in Excel—for Windows or the Mac. Note: ActiveX controls are not supported on the Mac.

You can assign a macro to a button on the Quick Access Toolbar or to a button in your own personal group on the ribbon. If you want a macro button to be available in other workbooks, assign it to a …

This procedure creates a button in the workbook that runs the script when the button is selected. It also shares the script with anyone who can edit the workbook.

Slicers provide buttons that you can click to filter tables, or PivotTables. In addition to quick filtering, slicers also indicate the current filtering state, which makes it easy to understand what exactly is …

You can assign a macro to a button on the Quick Access Toolbar or to a button in your own personal group on the ribbon. If you want a macro button to be available in other workbooks, assign it to a …

Add a scroll bar or spin button to an Excel worksheet. The controls let you quickly enter or change a range of values.

You can create a form in Excel by adding content controls, such as buttons, check boxes, list boxes, and combo boxes to a workbook. Other people can use Excel to fill out the form and then print it if they …

Select Formulas > Create from Selection. In the Create Names from Selection dialog box, select the checkbox (es) depending on the location of your row/column header.

You can insert a button, sometimes referred to as a command button or push button, on a Microsoft Office InfoPath form template. Users click buttons to initiate an immediate action, such as submitting …

Microsoft Excel provides several controls for dialog sheets that are useful for selecting items from a list. Examples of controls are list boxes, combo boxes, spin buttons, and scroll bars.