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.

The slicer buttons don’t automatically update. How to update the button sort order in Excel Microsoft Excel won’t sort the buttons automatically — it isn’t a dynamic feature.