Results 1 to 2 of 2

Thread: Excel 2010 - drop down menus help

  1. #1
    Join Date
    Feb 2012
    Posts
    1

    Excel 2010 - drop down menus help

    Hi all..

    I am trying to establish my first co-office business that will allow for new, young entrepreneurs a place to work and start their business. I have tried to work on excel as much as I can but am now stuck with a Formula and would be MUCH indebted with any assistance or advice.


    Background:

    I will be offering 5 styles of rooms (Small to Large) that can house 1-5 people respectively. (Column B23 - Column B33 provides a drop down list of Suite Types 1-5)
    I have another column (Columb C23-C33) that provides a drop down list to allow the selection of whether the rooms are Window Facing or Internal rooms. The rent for a Window Facing unit will be 30% more than Internal Units.
    I have listed down the Internal Rack Rate of rooms for Suite 1 to 5 in Column E11 to E15

    HELP WITH: By inputing (through the drop down menus) the selection of (a) Suite Type (Colm B) and (b) Window/NonWindow (Colm C), I am hoping to be able to automate the Rent in Column E23-E33

    I would be MUCH helped with any advice ...

    *I use Excel 2010*

    Thank you !

  2. #2
    Join Date
    Jan 2006
    Posts
    605

    Re: Excel 2010 - drop down menus help

    To create the Drop Downlist in Excel 2010, first add the list for the datasource. To create the list for the drop down ,enter the data in a single column cells

    B4 – apple
    B5 – ball
    B6 – cat
    B7 – dog
    B8 – elephant

    The list can be added from the Data tab -> Data Validation ribbon. Select the cell / column where the drop down list should be displayed and choose the datasource in the following window. Now the dropdown list should appear.

Similar Threads

  1. Drop Down Box in Word 2010
    By jesuse in forum Windows Software
    Replies: 1
    Last Post: 24-03-2012, 04:48 PM
  2. How to hide drop down arrows in Excel
    By Rao's in forum Windows Software
    Replies: 2
    Last Post: 07-01-2012, 09:26 PM
  3. Unable to see drop down menus on websites in internet explorer 8
    By $Daiwik$ in forum Technology & Internet
    Replies: 5
    Last Post: 21-02-2011, 10:20 AM
  4. Why is my CSS not doing drop down menus?
    By Wajeeha in forum Software Development
    Replies: 5
    Last Post: 17-05-2010, 11:32 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,719,273.02875 seconds with 17 queries