Click an Excel worksheet cell that you've linked to a drop-down list. For example, if cell E1 displays a drop-down list when you click it, click that cell to select it.

Locking cells in a Microsoft Excel spreadsheet is among the most commonly used functions. Here’s a guide on how to lock cells in Excel.

Excel does not always handle a cluttered page very well, especially if you intend to use a workbook on multiple versions of Excel. In this example we will use the Worksheet_SelectionChange event as a ...

In this guide, you'll learn how to freeze top 2 rows in your Microsoft Excel spreadsheet and keep headers visible while ...

Sometimes it's necessary to split cells in a spreadsheet, and Microsoft Excel makes it easy enough to do.

Uncover hidden features, new uses for old tools, and handy workarounds to speed up your everyday work in the powerful spreadsheet application.

1] Select the unwanted rows in a single attempt on your worksheet to delete multiple rows in Microsoft Excel. 2] Now, press ‘ Ctrl + – ‘to delete the selection made.