Google Docs is a fantastic online word processor, and it’s easy to streamline repetitive tasks using dropdowns. With a few helpful tips, you’ll be able to take advantage of this powerful feature in your documents.
Custom Google dropdown menus are available for Docs and Sheets to speed up your workflow and reduce errors. Read on to find out what a dropdown menu is, why you should use this feature, and how to add time-saving dropdowns to your Google Docs and Sheets.
What is a dropdown menu?
A dropdown is the sort of menu you see at the top of Google Docs and in the toolbar. For example, theFile,Edit, andViewmenus are dropdowns.
The toolbar’s zoom, style, and font controls are also dropdowns, even though they look different. For any dropdown, the operation is simple. Click it to open the menu, then click the option you want.
Why should I use dropdowns?
There are several good reasons to use dropdowns. This handy control improves speed and accuracy while making data more accessible.
A dropdown eliminates typing since you only need two mouse clicks to enter information. That makeswriting repetitive letters in Google Docsor filling out tables in Google Sheets faster than typing everything out.
Some people have trouble typing on a smartphone, even if it’s a bigGoogle Pixel 7 Pro, so dropdown menus are particularly helpful when writing or entering data on the small touchscreen of a mobile device.
Dropdowns also eliminate typos and make accuracy much better. If the dropdown is filled out correctly, it results in correct spelling and uses perfect grammar for that portion of your document every time.
Finally, a dropdown removes the need to memorize data. A long list of product numbers can be placed in a dropdown to make that information instantly accessible without checking against a product list.
How to add a dropdown in Google Docs
Dropdown menus can be added to a Google Docs document with two clicks. Place your text cursor wherever you’d like the dropdown to appear.
You can use dropdown menus on your smartphone. However, you can’t insert one from the Google Docs app. You need a desktop browser.
You can place a dropdown at the start of a new line or within a sentence. You can even use dropdowns in headers and footers.
ClickInsertfrom the top of the Google Docs page or type the at symbol “@” and chooseDropdownfrom the context menu. Google added a couple ofPreset Dropdowns, and you can selectProject statusorReview statusif those are what you want.
If any other dropdowns have been defined, they’ll also appear in the menu. You can hover your mouse pointer over any dropdown to see its options.
How to create a new dropdown in Docs
If presets and predefined dropdowns don’t suit your need, you can quickly create your own if you can access a desktop browser.
Adding color to dropdowns helps the user distinguish between each option, adding another visual cue that something can be changed and alerting the user to its current state.
How to add a dropdown in Google Sheets
Google Sheets is surprisingly powerfulfor an online spreadsheet. There are several ways to add a dropdown in Google Sheets. The most obvious is theInsertmenu, but you can also right-click any cell or type the at symbol “@” and chooseDropdownfrom the context menu.Dropdownis also an option inData validation, but it takes longer to add it this way. Let’s choose the easiest option.
Data validation is the only way to add dropdowns from a smartphone, and it’s only available on the Android app.
Make dropdowns from a data range
Google Sheets offers other options for dropdowns. Most notably, you can make a dropdown that fills in the options from a data range in your sheet.
If you have named ranges in a sheet, you can type the name instead of selecting a range with the options.
Advanced options for Sheets dropdowns
For a more refined dropdown, clickAdvanced optionsto reveal additional customizations.
If you check the box besideShow help text for a selected cell, you can type in a prompt to assist users.
There’s a data validation control with a choice to show a warning or reject input when the entered data isn’t found in the list of acceptable options.
The final advanced option isDisplay style. The default is aChip, which has rounded ends and an arrow.
TheArrowoption is a cleaner look that only adds a downward arrow to the right side of cells.
ThePlain textoption gives no visual cue that this is a dropdown and requires a double click to open the menu.
Google Docs dropdowns make data entry easier
It takes only seconds to create a dropdown, and you’ll benefit every time you use it. Instead of memorizing data, you can pick it from a list. No need to worry about typos when choosing from a menu of options.Even if you use Grammarly in Docs, it might not recognize some words specific to your work. Dropdowns are a great convenience feature in Google Docs and Google Sheets.
