1

I'm making entries on a daily basis and one of the cells I'm filling in is drop down with 20+ options. For ease I can start type the option I need and I wondered is there a hot key to complete the one that I'm typing?

I have looked at http://webapps.stackexchange.com/questions/30247/keyboard-shortcut-to-open-a-drop-down-list-for-cell-values-in-google-docs-spread but that does not help. While typing if I press enter it just creates a new one. Let's say I need "accommodation". I can start typing "acc" and see it, what hotkey is going to complete the rest? Tried with tab, space, ctrl, enter... they didn't work.

Improve this question
4
  • 1
    Possible duplicate of Keyboard shortcut to open a drop-down list for cell values in Google Docs spreadsheets
    – Rubén ♦
    Nov 15, 2016 at 17:55
  • that does not help, while typing if I press enter it just create a new one. Let's say i need "accommodation", I can start typing "acc" and see it, what hotkey is going to complete the rest. Tried with tab, space, ctrl, enter... they didn't work
    – salmonOnATrampoline
    Nov 16, 2016 at 14:43
  • Press Down/Up until the desired option is highlighted, then press Enter.
    – Rubén ♦
    Nov 19, 2016 at 1:01
  • 1
    @pnuts Another reason we need to encourage people not to leave important information in the comments.
    – ale
    Dec 14, 2017 at 13:37

1 Answer 1

Reset to default
1

In Google Sheets is there a key or hotkey that can complete an entry from a drop down cell?

No.

Available hotkeys are shown here.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.