Excel: Create input mask - how to proceed

In Microsoft Excel there are many functions that make your work easier. For example, if you need to enter a collection of addresses into an Excel spreadsheet, it is a good idea to use an input mask for a better overview and faster work. Learn how to activate and use the input mask function in Excel.

How to activate the input mask

Before you can use the input mask function at all, you must first show the corresponding option via Excel's settings. To do this, follow these steps:

1. Start Excel and access the options via the main menu.
2. Switch to the "Toolbar for DeepL access" category.
3. Select "Select commands" from the drop-down menu and the "Commands not in ribbon" category.
4. Find the "Mask..." option in the list, select it and click "Add".
5. Click conclusively on "OK".

You will now find a new icon in your DeepL access bar above the ribbon.

Create and use input mask

To create an input mask, you need to enter the desired column labels in a row in your Excel spreadsheet. Then select the columns by holding down the Ctrl key and clicking on the letter above the columns. Then click on the input mask icon in the DeepL access bar to call up the input window. This will then give you the option to populate the columns you have named with data, set criteria, or search for content if data already exists.