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.

Excel allows you quite a lot of freedom to customize your user experience via the use of macros. This tutorial will show you how to create and name worksheets using an existing list via a macro.

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.