Making A List Or Drop-Down Menu In Google Sheets Easily

 dropdown Google Spreadsheets

The world is changing more and   people are looking for ways to stay organized and keep up with the progress. There are many services dedicated to this, but today we present a version of Google Spreadsheets . What is this service?

If you use Google Sheets, how make combo it? This article find the answer to these questions.

What is Google Sheets?

 Google Logo Leaves green background

Google Spreadsheets, formerly known as Google spreadsheets is a web service that provides spreadsheets with AJAX technology .

He introduced its beta on June 24, the 2006 version, but after improvements and get more attention from the public service has been created, we now know that Google Sheets.

With Google Spreadsheets can make all the applications you would expect in the functions spreadsheet with its own office programs.

This is a service to the hand of your Browser that is based on the use of spreadsheets to perform operations using cells.

Thanks to your toolbar is full marks for working with cells to perform mathematical operations or financial calculations make no margin for error. You can also perform logical operations that need this service.

In the same way, you can   sort the data or the contents of a spreadsheet or Google leaves be better organize,   leaves of use may calculate the important date store connected to a key phrase to remember and to keep everything


Speaking of keywords, if you keep looking for information on the stable system will be faster because their cells allow formulas to make the content. Already written

Save time and energy to the channels with information from the beginning of the document because in the end you get a total without making other calculations.

You have the freedom to sort the columns of your   table in the way that suits your needs the most. In addition, each file can include new sheets for different topics and information, these files can be xls, csv,   etc. Everything you did in your spreadsheets can be changed in the future if necessary. can even share a spreadsheet Google Sheets easily and provide access to a person or persons to whom it may be changed including data and dates are inserted, to be saved.

Done all in the comfort of your computer or from your mobile device you’ll find the app in the App Store. An application designed for use wherever you are.

How the list or drop-down menu of Google Spreadsheets easily?

 dropdown menu Google Spreadsheets

This time, we’ll help you discover how to make a list or drop down menus through a simple step by step.

Step 1

The first thing to do is go to “Google Spreadsheets” and open the required respective spreadsheet.

Step 2

Then you need to select the cell or group of cells where you expect to make the process of creating the list or drop down menus.

Step 3

At the top of the spreadsheet, you’ll see the toolbar go to “data” and in this selection “Data Validation” .

Step 4

In the “Criteria” you can select either “List of range” or “Object List”. The side of the box can find a place that cells’ll include in the list. On the other hand, separating comma, it will be possible to place the items are, but no space in writing.

By default you see that the modified cells in the process will have an arrow symbol down with. Remove this arrow unchecking “View button in the cell to display the list. “

If for some reason in a cell enter any data that does not match any element in the automated list will see a warning.

If you plan to maintain order and that users use only the items in the list, you must select “Reject input” with “If the data is invalid.”

At the end of the procedure select Save and you see the new list or drop-down menus in the cells of your spreadsheet.

Waits If you place a color that distinguishes a scrolling list of the other can get it into “Format” and then on the toolbar, select Tools “Conditional Formatting” and choose the color.


How useful did you find this content?

Click on a star to rate!

Average score 0 / 5. Counting of votes: 0

So far, no votes. Be the first to rate this content.

I'm sorry this content was not useful for you!

Let me improve this content!

Tell me, how can I improve this content?

Deja un comentario