Microsoft Excel Tips and Tricks - Computergaga

Home / Archives for Excel Tips

Create a Searchable Drop Down in Excel – Just Like Google Search

This blog post will take you through the steps to create a searchable drop down list in Excel – just like Google search.

This is a great Excel trick for working with large drop down lists.

In this tutorial we will use a list of 87 names that as we type into the drop down list, it searches the names, and the list shortens to show only those names containing that string of characters.

Completed searchable drop down list in Excel

There are a few formulas to write to get this searchable drop down list in Excel created. Everything is shown and provided in this tutorial. If you prefer a video. Check out the video tutorial below.

Watch the Video – Searchable Drop Down List in Excel

[Read more…] about Create a Searchable Drop Down in Excel – Just Like Google Search

Group Worksheets in Excel – Time Saving Excel Tip

This blog post looks at how to group worksheets in Excel, and a couple of reasons why you would want to do that.

This awesome little technique can save tons of time and seriously improve your productivity.

Why would you want to group worksheets?

By grouping worksheets you can make the same change to multiple worksheets at the same time. This can be a formatting change, a structural change such as inserting a row, or even a formula.

[Read more…] about Group Worksheets in Excel – Time Saving Excel Tip

Interactive Checklist in Excel

In this blog post, we look at creating an interactive checklist in Excel. The checklist will automatically mark the items in a list when they are checked.

To do this we will first need to insert checkboxes onto the spreadsheet, we then need to be able to highlight an item when it is completed.

In this tutorial, I am using the idea of a Christmas shopping list of names (shown below). Your checklist could however be for any list of tasks, inventory or products.

Interactive checklist in Excel
[Read more…] about Interactive Checklist in Excel

Creating Multiple Dependent Drop Down Lists

Drop down lists can be created in Excel to assist with data entry and to prevent potential typos and misspellings. In this tutorial, you learn how to create multiple dependent drop down lists in Excel.

If you have lists with many entries, you may need to break the list into multiple dependent drop down lists. By creating a cascading set of lists, the entry in one is dependent upon the selection made in another.

[Read more…] about Creating Multiple Dependent Drop Down Lists

Type Special German Characters in Word/Excel

I have started to learn German as it has always been a goal of mine to learn the language. So I started to list some vocab in Excel to test myself.

I am using an English keyboard and the German language contains 4 special characters that do not appear on an English keyboard. You have the 3 umlaut accented characters ä, ö, ü and the ß (esszet).

There are two main ways to enter these letters into Word or Excel. One way is to insert the symbol, and the other is to use the number code associated with each character.

[Read more…] about Type Special German Characters in Word/Excel