Results 1 to 4 of 4

Thread: display down

  1. #1
    3 Star Lounger
    Join Date
    Oct 2001
    Location
    Toronto, CANADA.
    Posts
    292
    Thanks
    21
    Thanked 3 Times in 3 Posts

    Red face display down

    hello everyone;

    i am running excel from office 2003.

    years ago, i set up a feature which, by just positioning the cursor over a selection of the standard menu, would display down its contents, like a scroll rolling down. it is great time saver.

    please forgive me if my description IS NOT very accurate, but i know this feature exists, and i cannot implement it again when i try to customize my toolbars.

    is it there a way to do it?

    is it may recollection correct that it was for excel and not for other program?

    any hint / help / guidance will be appreciated.

    TIA.

    daniel rozenberg.

  2. #2
    Silver Lounger RolandJS's Avatar
    Join Date
    Dec 2009
    Location
    Austin metro area TX USA
    Posts
    1,730
    Thanks
    95
    Thanked 128 Times in 125 Posts
    My guess is you're looking to reconstruct a macro? I hope you find it! Let us know when you reImplement it! And, tell us how you did it.
    "Take care of thy backups and thy restores shall take care of thee." Ben Franklin revisited.
    http://collegecafe.fr.yuku.com/forum...-Technologies/

  3. #3
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,637
    Thanks
    115
    Thanked 650 Times in 592 Posts
    Would you by chance be describing Data Validation where the user clicks a cell then Is able to make a selection from a drop down?

    DataValidation.png

    If so, it is accessible from the Data Tab > Data Validation > Settings tab > Allow: List

    The source can be a range where the values in the list are taken from:
    =Sheet2!$A$1:$A$10

    Or a custom list separated by commas:
    DataValidation 2.png

    HTH,
    Maud

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    If you are referring to the toolbars at the top of the screen (assuming you are still using 2003), do you mean this option:
    View - Toolbars - Customize, on the Options tab click the 'Show full menus after a short delay'
    ?
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •