Skip to main content

How do I Create a Google Sheets Dropdown List?

Drop down Lists may be easier than one thinks to create. One beauty of using drop down lists is it narrows down choices and saves time depending upon what one is using the lists for. Please follow these steps for creating your drop down list.

Creating a Google Sheet Drop down List

  1. Open a Google Sheet
  2. Click the Cell for the Drop down List
  3. In Toolbar Click Data
  4. Select Data Validation
  5. Click "List from a Range" Down Arrow 
  6. Select "List Type"
  7. Type Data
  8. Click  Save  Button

 I sure hope you find today's tip helpful! 
                                                                    Best, Ms. Drasby


Popular posts from this blog

What Google Doc Font should I use for my Egyptian Project?

There are literally hundreds of font styles to choose from for a Google Doc. If I was creating a project about Egypt there are two fonts which I might use for creating titles and headings. The font styles I like are Algerian and Caesar.  

You can learn about installing Google Doc Fonts from the following Google Doc Help Center Article: Edit and format a document. Please pay special attention to the "Format your Font" section.

                                                                                      Best, Ms. Drasby

How do I create exponents when using Google Slides?

I know writing math equation can seem like a challenge when using Google Slides. The following video demonstrates how easy and quick it is to create exponents in a Google Slides.

Best, Ms. Drasby

Can I Create Columns In a Google Doc?

Creating columns is a tool which was added earlier this year to Google Docs. It is a little tricky to use. If you choose an amount of columns right away you will have to type to the bottom of the page before the words continue in the next column. This works well if you are planning to use two or three column text to fill the whole page. However there may be times you only want to fill part of a page with two or more columns. So what do you do to make columns work?
Creating Partial Page ColumnsFirst type a Paragraph Highlight the Text In Toolbar Select Format Scroll Down & Choose Columns Select Amount of Columns