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.

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.

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 …

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 cannot create a hyperlink directly in a workbook in Excel Services. Instead, you must create or edit a hyperlink in a workbook by using Excel, and then publish or upload the workbook to a document …

Check boxes are a versatile feature in Excel, useful for making interactive lists and forms. In this article, we'll cover how to add, remove, and toggle them. Insert check boxes Select the range where you …

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 …

Use AutoFilter or built-in comparison operators like "greater than" and "top 10" in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or table, you can either reapply a …