Is it possible to create a search box in Excel, without using VBA?
Yes, and it’s easy!
We will use Conditional Formatting to highlight the fields that match the search string. For example, if you look at the table below, we want to highlight row 8, 11, 15 and 25 if we search for “RG”, because “RG” is part of the product name in those rows.
READ MORE
Have you ever imported data into Excel that won’t calculate? Look at this example where the earnings look like numbers to the human eye, but not to Excel. And when Excel is not able to identify any numbers, it can’t calculate any sums or averages either.
This happens all the time if you use data from other data sources: It could be a txt-file from a booking system, a copy-paste from a website or even a database export.
Enough about the problem. Let’s solve it, and let’s not spend more than 2 minutes doing it!
Wouldn’t it be cool if you could have a yellow info note that pops up when you select the cell in Excel? Actually you can! Let’s look at a little used feature of Data Validation.
It’s easy and you can do it in less than a minute!
READ MORECreating a drop-down menu in Excel may look difficult, but it’s actually super easy! It won’t take you more than 3 minutes the first time you do it, and when you get the hang of it, it only takes a few seconds!
Just follow these 3 steps to create a drop-down list in Excel: