Keystroke to enter drop-down list?

  • Thread starter Thread starter Bruce Cooley
  • Start date Start date
B

Bruce Cooley

Is there is a way to enter a drop-down list from the keyboard instead of
using a mouse? Thanks in advance.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop-down list and error message 1
drop down list 1
combobox 4
Drop Down List 2
Drop down list from index/match formula 1
Data Validation and drop-down list using IF, AND and what else? 8
Restrict Choice in Shared WB (drop down alternative)? 0
data validation list 17

Back
Top