If there are many blank rows in your Excel sheet, you can delete them and tidy up the document using the "Find and Select" feature. Here's how.

To edit a drop-down list in Excel, you can use a number of tools depending on how you created the list. Here's what you need to know.