drop down boxes

Hi, Any help in creating a simple drop down list will be appreciated. Checked previous threads, but was confused by validation and linking spreadsheets. Just need a basic drop down to choose one of several options not linked to anything. Thanks, Steve

I've created a pivot chart but want to simplify it for the users. We have 16 different districts, and within each district there are separate offices, all numbered numerically. I would like to be able to have a district manager choose his specific district and then choose a specific office...

I'm working on a raw data file received from someone else that has built in drop down boxes that are limiting the amount of manipulation I can do. Specifically, to create new columns and formulas. Is there any easy way in Excel 2007 to remove these types of drop down boxes and essentially...

I am new to drop down lists. See below example. List of Fleet Vehicles redcar bluecar greencar blackcar ..etc I want to be able to choose from this list and after choosing an item, I don't want it to be available again, unitl it has been cleared from the cell. Is this possible?

Hi! I am hoping someone can help me. I have small sized set of data ( 5 columns, 250 rows) that i would like to be able to sort with drop down boxes--with some level of hierachy. (ex drop down selection should only show relevent rows) I would like drop downs menus on each of the five header...

Hi all, not sure ive used the correct terminology in the thread field but ill explain my situation. I have a vat of information that needs organised and much of this can be placed in repetitive fields, hence the drop down list. I want to organise the information in a sort of family tree...

Hello, I want to protect a sheet, showing lots of information that will change when selecting one of the parameters from the drop down box. If I use the format control and it is not 'locked' when protecting the whole sheet, when changing values in the box it says that the sheet is protected...

Im currently creating a drop down list for a range of cells. The range of cells I have chosen use the formula =IF($G$2=A3,A3,NA()), thr problem is that when they are showing NA they still appear in the drop down list is there any way of stopping this from heppening. Any help would be much...

Okay..I watched dozens of video's emailed with someone who makes those vids...but still haven't got an answer. I would love to upload a screenshot but I can only post a link(?..*gets more frustrated knowing he can't get a clear explanation and answer in one simple try*) I will type an example...

Hey guys, I work in transportation and i'm trying to create a schedule report. My problem is that because of holidays and weekends the dates in the report change. For example, if the plane is to arrive tuesday. My formulas will automatically set dates so the clients can send their products...

I am working on a project and need some help. I am creating a template used for quoting at my company. I want to create a standard template used for all commodities. To do this I have several columns that need to be on every quote and then depending on the commodity, a few other columns...

I am trying to have a drop down list with various choices in text, e.g. Male and Female in a form for entering data. However, in the table, I would like the return values to be 1 if it is Male, and 2 if it is Female. Does anyone know an easy way this is done? Thanks in advance.

I'm using a data validation with the criteria being two values, a check mark and an X from wingdings. Arial doesn't have either of these so I had to use wingdings. The problem is, the drop down menu converts them to arial which makes the two possible values a different versions of a "u". The...

Solver and Drop down menus problems I'm trying to use Solver to Optimize a simulator I built in excel. The target cell is Market Share and the adjustable cells are drop down menu links. In other words, the drop down boxes change the price of a product and that affects the share. The issue I'm...