How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask John D Your Own Question
John D
John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9666
Experience:  Worked on Macs and PC's for 20+ years.
53785
Type Your Mac Question Here...
John D is online now
A new question is answered every 9 seconds

Is it possible to do horizontal list/droplist in excel

This answer was rated:

Is it possible to do horizontal list/droplist in excel?
-Could you explain your situation a little more?
Customer: replied 7 years ago.
Im making an yearly scheme over 2010 with
date,
week
month

on sepearate horizontal lines.
Veticaly im placing the activities.
To reduce the amount of columns in the document i would like to be able to place an horizontal list to make selections and be able to show only dates with activities. (just as i can do verticaly).

Is it possible an how do i make it?

Best

//martin

Martin.

 

Could you please send me the file to have a look at it. To do so go to www.wikisend.com and upload it. You will then get a page that has the download link. Copy the download link and come back here and paste it in your reply.

 

If the file has sensitive information let me know before you upload it.

 

Customer: replied 7 years ago.
Hello

Here is the download link. Hope it will help you understand.

http://wikisend.com/download/594286/Campain 2010_01.xlsx

Ok I think you are referring to "Filters" and not Drop Down controls. If so, Filters in Excel can only be applied in the columns. However I may be able to find a workaround if you can show me a sample output sheet showing how you would like to see the data when 'filtered' on Months for example.

 

John D and 3 other Mac Specialists are ready to help you