Microsoft Excel lets you add two types of buttons to a worksheet: option buttons and toggle buttons. Option buttons, also referred to as radio buttons, let you choose one item from a list.

Another way to quickly filter data in an Excel table is to add an Excel data slicer, a series of buttons representing different categories or values within your data.

Popular form tools include radio buttons and check boxes but you may also add a scrollbar. In Excel the scrollbar control allows users to scroll through a list of pre-formatted values or text.

Another way to manually add a table of contents in Excel is by using the Hyperlink Function. In this method, you need to type ...

Microsoft Excel sorts slider buttons alphabetically and numerically. Fortunately, you can add a custom sort list to sort the buttons in a more meaningful way, when necessary.

You can add a strikethrough in Excel by using the Font Settings button in the Font section of the Home ribbon. You can use the keyboard shortcut Ctrl + 5 to strikethrough Excel for Windows; on a ...

Here is a tutorial on how to add a watermark in Microsoft Excel. While Excel doesn’t provide any direct option to insert watermarks into your workbooks, you can still watermark an Excel sheet.

You can add a header and footer to Excel, and in this guide, we'll show you how. When you purchase through links on our site, we may earn an affiliate commission. Here’s how it works .

Knowing how to alphabetize in Excel can be a real time-saver. ... You could also sort in reverse order by using the Z-A button. ... we'll click Add Level to select Last Name from the drop-down box.

If you don’t see the Developer tab, do the following to add it: 1. Click the File tab. 2. ... Method two: How to run a VBA sub procedure by clicking a button in Excel.