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.

  • 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 – D.Dachkinov Nov 16 '16 at 14:43
  • Press Down/Up until the desired option is highlighted, then press Enter. – Rubén Nov 19 '16 at 1:01
  • 1
    @pnuts Another reason we need to encourage people not to leave important information in the comments. – ale Dec 14 '17 at 13:37
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, privacy policy and cookie policy

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