• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Digital Answers

How to tech tutorials in simple words

  • Home
  • About Us
  • Disclaimer
  • Privacy Policy

How to enable autocomplete in Google Docs Spreadsheet

August 24, 2011 by Admin 5 Comments

Autocomplete feature helps users by automatically filling the content of cell when users starting entering the first couple of letters in the Cell. The automatic entry is picked from the previously entered values for the same column.

Let us say you have got the following list of entries in one of the column

Arizona
Alabama
California
Florida
Indiana

Now when you start typing Ar in the cell below Indiana, Spreadsheet will automatically display Arizona based on the entries done earlier for that column. And when you press enter this value will be automatically filled for that cell.

You can enable Autocomplete feature in Google Spreadsheet by clicking the Tools menu and selecting Enable AutoComplete from list of available menus.

Remember that if there is a empty cell before the active cell then Autocomplete feature will try to pick from the below column values.

Filed Under: Excel, Technical Tagged With: Autocomplete, Enable, Google, Google Docs, spreadsheet

Reader Interactions

Comments

  1. Lisa says

    April 25, 2014 at 12:15 am

    I’m not sure why this isn’t working for me. I have two adjacent cells merged, could that be why? Here is an example:

    8 JOHN DOE OVERNIGHT Acct 1 # 12345
    $ 100

    The top and bottom are merged in most of the columns, because the column(s) on the right indicate job number (top row) and dollar amount (bottom row).

    If I get another shipment later in the day to John Doe, I would like to avoid creating two shipping labels to the same client. If autofill works, I can avoid that error.

    Thanks.

    Reply
  2. Ró says

    January 5, 2016 at 5:37 pm

    Thanks for this. Am I right in saying that this doesn’t work when an entry begins with a digit?

    Reply
  3. Yash says

    August 14, 2017 at 12:41 am

    Does work for me, but how long does it work thought?
    For me, it stops working after 200 rows. Is there any way it will pick up an auto complete after 200 rows?
    That’ll be a great help.
    Thanks

    Reply
    • Nate says

      October 21, 2019 at 9:13 pm

      I know this is old, but did you ever get the 200 rows thing figured out? I’m running into the same issue.

      Reply
      • Meeran says

        March 13, 2020 at 4:16 pm

        Hey Nate, Goto-> File -> Spreadsheet settings -> under calculation tab ->toggle iterations calc on, Change it to 10,000. Done

        Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Recent Posts

  • Disable conversion of two numbers with dash as date in Excel
  • How to Protect Formulas in Excel
  • How to Change the Default Font in Excel
  • How to Add Country Code to Phone Automatically in Excel
  • How to Insert Pictures in Excel

blogmines.com Copyright © 2023