Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Excel Drop Down Menu


  • Please log in to reply

#1
jho

jho

    New Member

  • Member
  • Pip
  • 4 posts
I created a drop down menu in Excel 2000 but, the drop down arrow for my custom menu is only visable when my curser is in the cell where I created the menu.

How do I make the drop down arrow visable at all times (regardless of where my curser is located)?

Thanks.
  • 0

Advertisements


#2
peterm

peterm

    Trusted Tech

  • Technician
  • 3,173 posts
How did you create the drop down
ther is more then 1 way in excell
  • 0

#3
jho

jho

    New Member

  • Topic Starter
  • Member
  • Pip
  • 4 posts
I went the Data tab, Validation and selected the range of data.

I tried to use the Auto Filter (which shows the drop down arrow at all times) but I need to create several drop down menus in the same column (one below another) and Auto Filter won't let me do that.

Any thoughts?

Thanks for your consideration.
  • 0

#4
peterm

peterm

    Trusted Tech

  • Technician
  • 3,173 posts
Ok pretty sure you can't have the drop down arrow showing all the time.
If you do it hides part of the data in the next cell.
or try this
Excell
  • 0

#5
jho

jho

    New Member

  • Topic Starter
  • Member
  • Pip
  • 4 posts
Thanks for your help.
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP