Keystroke to enter drop-down list?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bruce Cooley - 29 Jun 2005 22:32 GMT

Is there is a way to enter a drop-down list from the keyboard instead of
using a mouse? Thanks in advance.

Signature

Bruce Cooley

Reply to this Message

Anne Troy - 29 Jun 2005 22:44 GMT

Alt+Down Arrow
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

> Is there is a way to enter a drop-down list from the keyboard instead of
> using a mouse? Thanks in advance.

Reply to this Message

Bruce Cooley - 29 Jun 2005 22:48 GMT

Thanks much!
Bruce

: Alt+Down Arrow
: *******************
: ~Anne Troy
: www.OfficeArticles.com
: www.MyExpertsOnline.com

: > Is there is a way to enter a drop-down list from the keyboard instead of
: > using a mouse? Thanks in advance.
: > Bruce Cooley

Reply to this Message

zhy - 30 Jun 2005 04:32 GMT

I have a way to do that, no need to use macro or change the system clock,
but a little bit much operation
after you entered all the date of the year 2005 as default, you just enter
365 in a cell and copy it, then select all the cells with the date you want
to change to 2004, from menu Edit-pastespecial-substract
. You may get a lot of numbers, change the cell format to date at last.

"Bruce Cooley" <bcooley@teleport.com> Ð´ÈëÏûÏ¢ÐÂÎÅ:xOKdnfcTvsILjl7fRVn-gw@comcast.com...

> Is there is a way to enter a drop-down list from the keyboard instead of
> using a mouse? Thanks in advance.

Reply to this Message