Find all the cells in a worksheet to which you've applied data validation

If you need to add worksheets to an Excel file, chances are that you use the Insert | Worksheet menu command. There's a much faster way to go about this task: Simply press [Shift][F11] and Excel adds a new blank worksheet before the active worksheet.

If you need to add several worksheets to a workbook, you can use either technique to create all of the sheets at once. While holding down the [Shift] key, click on the same number of worksheet tabs as new sheets you want to create. Then, use either the menu command or shortcut key as you normally would.