Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

drop down boxes

ResolvedVersion 2007

Helen has attended:
Excel Advanced - Formulas & Functions course

Drop down boxes

Is there a keyboard short cut to access a drop down box within a cell so you don't have to click on it?

RE: Drop down boxes

Short answer is no, sorry ;)

RE: Drop down boxes

Hi Helen, is it your own workbook & drop down list / box?
If so you could create a Macro which would take you straight to the actual cell containg the drop down box / list. If, that's IF you know what is on your list, continue to type in the box then just hit the return key.

Baz

Excel tip:

Date and time

CTRL+ SEMICOLON then SPACE then CTRL+SHIFT+ SEMICOLON

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.