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.
 
Back
Top