excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi i was wondering how to make a drop down box so i can select a name for
say my taxinvoices for my clients instead of having to type in the whole
thing
thank you
 
you should use Data Validation feature.
select the range of cells where you want a drop down list.
go to menu Data > Validation > under Allow options select List and type
tax invoice numbers in Source field each seperated with a comma.
instead of typing invoice numbers in Source field, you can put a
reference of cells which contain invoice numbers.

hope this would solve your problem.
 

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

Back
Top