Announcement

Collapse
No announcement yet.

OT: need some help with MS Excel

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • OT: need some help with MS Excel

    Hi all,

    I need some help from those of you that are fluent in Microsoft Excel.

    I am trying to create a spreadsheet with a few of those little drop-down lists, you know the ones that have a little down arrow beside the cell you want to enter information into and when you click on it it gives you a drop down list of choices.

    I have searched through excel's help section both internally and online to no avail. Anyone have any idea how to do this? Any help will be appreciated.

    Tim

  • #2
    try this
    http://office.microsoft.com/en-us/ex...005202215.aspx
    fairly easy, also look at conditional formatting, makes things easy to spot
    regards
    mark

    Comment


    • #3
      Many thanks

      Thanks Mark,

      That did the job.

      I appreciate your help

      Tim

      Comment


      • #4
        Excel contains a complete BASIC programming environment which allows the creation of all sorts of special functions within a spreadsheet. The BASIC IDE is much easier to use than similar stand alone development environments.
        Free software for calculating bolt circles and similar: Click Here

        Comment


        • #5
          the filter button is usually a quick way to do what you want

          however it will give you more drop downs then you may need, but its only a single click
          https://www.flickr.com/photos/csprecision

          Comment

          Working...
          X