Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
Someone recently asked me if it was possible to get a main category and subcategory in a drop-down list in Excel, (something as shown below): My first thought was to do this using VBA (if possible), but the answer is so easy, it surprised me. Creating Subcategory in Drop Down List in Excel All you need …
Data Entry in Excel could be a very boring task. Suppose you have a template as shown below, and you have to enter data in excel in all the cells highlighted in red, in the order specified by the arrows. While this seems easy enough, it could be nerve-wracking when you have many such non-contiguous …
You would have seen this in various online forms, where you must fill a cell before moving to the other. This makes sure that you’re restricted unless you make certain data entry (or fill a certain field). For example, you may not be able to choose the state unless you have selected the country first. …
Excel has its own limitations, and in this blog post, I will show you how we can use one of the limitations to our advantage. Get the Last Number in a List in Excel using Excel VLOOKUP Function The largest positive number that you can use in Excel is 9.99999999999999E+307 (I tried this in Excel 2010). …
There are many lookup functions in Excel (such as VLOOKUP, LOOKUP, INDEX/MATCH, XLOOKUP) that can go and fetch a value from a list. But you can’t look-up images using these formulas. For example. if I have a list of team names and their logos, and I want to look up the logo based on the …
Conditional Formatting is one of the most simple yet powerful features in Excel Spreadsheets. As the name suggests, you can use conditional formatting in Excel when you want to highlight cells that meet a specified condition. It gives you the ability to quickly add a visual analysis layer over your data set. You can create …
There are only 3 Excel wildcard characters (asterisk, question mark, and tilde) and a lot can be done using these. In this tutorial, I will show you four examples where these Excel wildcard characters are absolute lifesavers. Excel Wildcard Characters – An Introduction Wildcards are special characters that can take any place of any character (hence …
Fill Handle is a feature in Excel that enables you to auto-complete a list in a row/column by simply dragging it using your mouse. A basic understanding of fill handle in Excel could save you some time and make you more productive. What’s this Fill Handle in Excel? ‘Fill Handle’ is a tool that you …
You can easily add bullet points in a cell Excel (Yes.. easily). Until I knew this trick, I used to put a dash (-) or arrow greater than (>>) at the beginning of the text, and that could sometimes be a pain. I always wondered why was Excel devoid of such basic functionality. But that …
©trumpexcel.com – Free Online Excel Training
