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.

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.

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.