Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.

If Tabs are missing or not showing in your Excel worksheet, it may be due to some changes within your Excel settings. Take these steps to fix the issue.

Follow the steps below to create a drop-down list using data validation in Excel. If you want to add a message pop up, you can click the Input Message tab and check the checkbox for “Show input ...

In the January column (page 82) a reader asked how to display 36 workbook tabs in Excel. We described several solutions, but reader Mary Jo Gruber, a CPA with a St. Louis public school district, ...

Build a custom Excel function library in minutes! Learn how to use VBA, create a personal macro workbook, and design a custom ribbon tab.