To make your table, click anywhere on the data with the header “Fruit Table”, then press Ctrl+A, and then Ctrl+T.
CREATE A DROP DOWN LIST IN EXCEL 2011 FOR MAC UPDATE
Here, you want to do because your data validation will automatically update if you change anything in your table.Īlong the way, let’s practice some shortcuts. Naming tables in Excel is incredibly useful and best practice for a variety of reasons. You might be saying, “But that data is already in a table!” Well, unless you have officially named it - it’s not yet in a table. You’ll learn much better that way! Here’s what my Excel sheet looks like:įirst, make a table in Excel. While you might need the article so you can follow along for your learning, make sure you are actually doing each of these steps in Excel. (If you don’t want to keep it in your pocket, just bookmark this page.) Let’s Make That Drop Down List in Excel So whether you love it or loathe it, the drop down list in Excel is a great tool to keep in your pocket for a rainy day. And I’ll give this to them: a drop-down does allow for less variation in data entry, which can definitely be a problem.
To be honest, I’m not a huge fan of the drop down, but it has its fervent supporters. But trust me, when someone wants a drop down menu, they won’t settle for anything else. After all, it’s not something you need every day. Whether you’re an Excel novice or a whiz, you might not know this skill.
0 kommentar(er)
