How to create a drop-down list in Excel and save yourself hours of time

Maria Diaz / Elyse Betters Picaro / ZDNET There are plenty of apps and websites available to keep you organized and on task, but for raw data power, nothing beats Microsoft Excel -- and for repetitive tasks, its drop-down lists are a real game-changer. Whether you're juggling a side hustle, keeping tabs on family schedules, or just trying to make sense of a mountain of numbers, drop-down lists are a godsend that speed up typing. They can also cut down on typos and just keep everything looking neat. Also: How to use ChatGPT to write Excel formulas Here's how to add them in Excel fast -- plus a few expert tips to tweak and style dropdowns to your liking. How to add drop-down lists in Excel What you'll need: You'll need a Microsoft 365 subscription to use Excel, whether you're on the web or the desktop app. I'm working from the desktop version here, so if your menu looks different online, Microsoft's support site can help you bridge the gaps. And yes, Google Sheets (and other tools) ... Read full article.