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.

4
  • 1
  • 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 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

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.

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.