Microsoft Excel: How to Remove a Drop-Down List. Excel's drop-down menus are useful for creating order forms and navigation for larger files like records of sales.

Expand the options by clicking on the arrow button appearing next to the ‘ Delete ’ option. Now from the drop-down menu select ‘ Delete Sheet Rows ’ to remove the unwanted rows.

To clear formatting from the selected cells in your workbook in Microsoft Excel, you can use Clear Formats, Keyboard shortcuts, Format Painter tool, etc.

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.