![]() To make your table, click anywhere on the data with the header “Fruit Table”, then press Ctrl+A, and then Ctrl+T. 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. By Rich Rinaldi on Februin Advanced Excel Functions and Formulas, Excel FormattingĪt some point, you’ll be asked how to create a drop down list in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |