Free Microsoft Excel 2013 Quick Reference

MAYDAY! Menus producing a "ghost" box rather than a drop down list

Folks I have a big problem - I am using MS Office 2003 Student /
Teacher edition and am desperately seeking help. My machine is a
P4/3.2 with 2gb ram and a disgusting amount of disk space running XP
Home.

What the problem is is that when I try to access ANY of the commands
on the second line (e.g. File / Edit / View / Insert / Format etc.) I
get a ghostly light gray transparent box instead of the usual drop
down list of commands.

This is whether I use the mouse or the various Alt-commands. The ONLY
keyboard shortcut command I've been able to get to work is alt-F4
which I don't think is on this second line.

I tried to get help from Microsoft but their system demanded my PID -
which naturally I have to access to Help / About etc. (Gee thanks!)

I am fairly sure that I have something garbled in my setup (Excel has
been working flawlessly on this box for more than a year until now)
since while I am the main user on the system I am not the ONLY user on
this machine and Excel works perfectly on my wife's account. This is
not much of a work-around of course since I have lots of templates I
use all the time which she does not have access to.

I've checked the XLSTART folder at C:Program FilesMicrosoft
OfficeOffice10XLStart but that didn't do the trick. I vaguely recall
from my tech support days of 10 years ago that there was a default
file of settings in a file called something like book.xls or book1.xls
which plays the same role to Excel that normal.dot does to MS Word.
But I don't see such a file anywhere (a LOT of MS Word problems can be
solved simply by renaming Normal.dot and letting MS Word recreate the
file with the system defaults) so I'm stuck.

I'm also thinking this might be a simple Regedit fix which I know
enough about Regedit to manage but DON'T want to go in there without
advice from someone more knowledgeable than me. Since Excel works just
fine on her account it's got to be some garbled .ini file or something
like that - I'd be happy to copy hers over mine if some "MVP" figures
that's a good fix

Since Murphy is very much alive and well you KNOW this sort of thing
is going to happen on a Friday afternoon when you're facing a tax
deadline on Tuesday and were planning to work around the clock to get
it done right? Does it ever happen differently?

Any replies would be HUGELY HUGELY HUGELY appreciated.


Post your answer or comment

comments powered by Disqus
Hi,

Attached is a sample in which Sheet1 contains list in which the ColumnF contains a Drop Down box which have values from Sheet2. Now when a value is selected from Drop Down List the Place,Mandal and School ID columns in Sheet1 are to be filled from the corresponding Place,Mandal and School ID columns in Sheet2 and the row in sheet2 has to be deleted.Next the original Place,Mandal and School ID columns in Sheet1 are to be copied to Sheet2 and sorted first by mandal and then by Place.Now the available Drop Down List in Sheet1 after the last operation should be the latest one with Place selected removed and Place copied included.

Hope I explained what I am required.

Thank you in advance.

Hello all,

Having an annoying time with trying to work out how to limit entry into a field. I have created drop down lists for a number of columns, using the data validation procedure in Excel 2007. These drop down lists change dependent on entries in other columns.

For my first column drop down list, in my Settings tab, I have 'List' selected and the following criteria written: =IF(B3="",CatList1,INDEX(BudgetAllList,MATCH(B3,SCClinList,0)))

This works in terms of the drop down. No problem there, but I'm still able to override the drop down list and enter any old jargon into the field. I want the person who enters the data to only have the option of using the drop down list. Anybody know how to restrict this? I've tried adding a STOP Error alert but that hasn't help.

Many thanks,
sparkes84

I am trying to create a spreadsheet and add an auto fill function and finding a bit rusty after not having used macros for a long time.
My spreadheet example is attached. What i am trying to achieve is in my Master Sheet when i pick a site name from the drop down list using combo box, Site Manager's Name & RBM name should automatically fill in the mentioned boxes in Master sheet.

Help to achieve it will be greatly appreciated.

I have a spreadsheet with many many drop-down lists. Is there any way
for a user to enter the first letter of an option and automatically
jump to that option in the list?

The goal is to make this faster to use than (or at least as fast as)
writing it out, and right now, clicking on, scrolling through, and
selecting from each drop-down is a lengthy process.

--
Siobhank
------------------------------------------------------------------------
Siobhank's Profile: http://www.excelforum.com/member.php...o&userid=26133
View this thread: http://www.excelforum.com/showthread...hreadid=394611

Hi, I have a worksheet that has several drop down lists which show that protection is checked on when I go to format control and I have protected the sheet as well as setting the document up as read only unless you have a password. My problem is that if I right click on the combo boxes I can cut them out of the work sheet even in read only mode?? Please help. Thanks

Hopefully I can explain this clearly enough for someone to understand my issue.

I was asked to create an attorney confirmation form that could be mailed when printed. The form automatically returns the name and address of an attorney when selected from a drop-down list.

The drop-down list acts as the name of the attorney on the form and using the vlookup function returns the address and any other important information regarding that attorney.

The issue I'm dealing with arrives when the same attorney has more than one location. Since this is a mailing form I can only have the name listed as you would address it on an envelope. I am looking for a way to make a sub-category within the drop-down list so it will give you more detail about the attorney so you choose the correct location, but still only show the main category when selected.

Sort of looks like this I guess

Attorney A
- Miami location
- Ft. Lauderdale location
- West Palm Beach location

When you select any of the three options under Attorney A it will come up with the corresponding address and information for that account, yet will only show Attorney A on the form and not the subcategory.

Hopefully this makes sense to someone. Thanks for any help you can provide.

I have a spreadsheet with many many drop-down lists. Is there any way for a user to enter the first letter of an option and automatically jump to that option in the list?

The goal is to make this faster to use than (or at least as fast as) writing it out, and right now, clicking on, scrolling through, and selecting from each drop-down is a lengthy process.

Hello all,

I'm looking to set maximum values of a drop-down list based on the age profile of the relevant person. I wish to keep the drop-down list in place though.

The drop-down list consists of a list increasing in increments of 0.5% from 1% to 40%.

I wish to set the maximums as follows:

Up to age 30: 15%
Up to age 40: 20%
Up to age 50: 25%
Up to age 55: 30%
Up to age 60: 35%
Aged 60 and above: 40%

Is there any way I can enter a formula to allow this?

Many thanks.

I'm somewhat new to excel and I'm trying to create a cascading drop-down list.

In my form what I've started there are three columns. The first column contains a heading. The second and third columns contain the drop down list.
Additinally the list data is contained on sheet2 and sheet 3.

In column 2 the drop-down list should reference sheet2:B1 and sheet3:B1
When

My problem is fiding a way to have the drop-down list in column 3 change based on the selection in the drop-down list for column 2. Addditionally the user shouldn't be able to change there selection and the selection should be recorded.

How do I do this? I've attached the spreadsheet.

I can't figure out how to filter a certain data set by a date range using two drop down lists.

I would like to be able to enter a Start Date and End Date from two drop down lists to filter the data that falls between certain dates. Autofilters is too time consuming, because I need to filter between certain date ranges constantly.

Any help would be much appreciated, I've been trying for a while to do this with no luck. Thanks!

I am trying to create a form that contains conditional drop down lists for
the user to selct from. i want the user to be able when theypick from a list
i created in cell D3 and when they choose that i want a list to be created in
cell E3 which contains data from a second worksheet. I was able to make it
work using nested if statements for validation but the problem is that it
wont let me go past 7 and i need to do about 50 of them. To make things
easier i defined names to reference all the data on the second worksheet.
This is what i used and it would work if i could do about 50 of them
=IF(D3=K13,Roc,IF(D3=K14,Roc,IF(D3=K15,Camino,IF(D 3=K16,Camino,IF(D3=K17,Admin,IF(D3=K18,Arroyo,IF(D 3=K19,Atascadero,IF(D3=K20,Grover))))))))
matching the cell D3 to data i used to create the list really just matching
itself to itself.
I know there has to be some simple VB code to make it work or some simple
solution, and i do have some experience using vb code but not in this kind of
enviroment.
Does Anyone have any ideas?

Hello all,

I'm looking to set maximum values of a drop-down list based on the age profile of the relevant person. I wish to keep the drop-down list in place though.

The drop-down list consists of a list increasing in increments of 0.5% from 1% to 40%.

I wish to set the maximums as follows:

Up to age 30: 15%
Up to age 40: 20%
Up to age 50: 25%
Up to age 55: 30%
Up to age 60: 35%
Aged 60 and above: 40%

Is there any way I can enter a formula to allow this?

Many thanks.

P.S. I've attached a file for what I mean. Basically I want to restrict the entry value of cell B13 by whatever value is in C5. I would prefer to leave the drop-down list as is regardless, but to restrict the acceptance of certain values being entered based on C5.

Hello,

I want to protect a cell that I have a drop down list in, but I still want the drop down list to work.

When I try to protect it, the user is not able to use the drop down list to select other items. I didn't see an option on the protect sheet area.

Thanks for any help.

Nick

I am trying to create a form that contains conditional drop down lists for
the user to selct from. i want the user to be able when theypick from a list
i created in cell D3 and when they choose that i want a list to be created in
cell E3 which contains data from a second worksheet. I was able to make it
work using nested if statements for validation but the problem is that it
wont let me go past 7 and i need to do about 50 of them. To make things
easier i defined names to reference all the data on the second worksheet.
This is what i used and it would work if i could do about 50 of them
=IF(D3=K13,Roc,IF(D3=K14,Roc,IF(D3=K15,Camino,IF(D3=K16,Camino,IF(D3=K17,Admin,IF(D3=K18,Arroyo,IF(D 3=K19,Atascadero,IF(D3=K20,Grover))))))))
matching the cell D3 to data i used to create the list really just matching
itself to itself.
I know there has to be some simple VB code to make it work or some simple
solution, and i do have some experience using vb code but not in this kind of
enviroment.
Does Anyone have any ideas?

for example, if cell A1=0, then A2 shows drop down list #1, if not, A2 shows
a different dropdown list#2

Hi,

I wonderr if anyone can tell me if i am able to insert into an excel
spreadsheet an address bar drop down list (like in windows explorer) to view
and select the necessary drives, and make this particular cekk work like a
pointer to changing the default path of where my macro searches for a
specific file.

Thanks

Hello,

I am trying to set up a spreadsheet in which you can describe a product based on criteria listed in 4 drop down lists, so that your selections from the 4 drop downs identify a specific product out of multiple possibilities. I then want to be able to auto-calculate the price (selected from a price list on another worksheet) of the specific product described by the four drop down selections.

Any recommendations on the best way to do this price calculation?

Please see the attached spreadsheet sample to illustrate what I am trying to do.

Thanks!

hello im new to this forum and have seem you are very helpful and knowledgeable , so as i am making a time sheet in excel i want to add a type of AM / PM drop down list , so when the user inserts the hour can specify if it is AM or PM , but besides that i need that the resulting cell has the time entered and the AM or PM selected , example : if 2:45 is entered and PM is selected , the cell should read : 2:45 PM , would apreciate your help, thanks : )

or if there is a more easy way to get the same result would like your coments : )

I want one of the columns in my spreadsheet to have a drop down list box, but
I also want to be able to select more than one value from the drop down box
as a value for each cell. Is this possible and if so, how? Thanks!

I have two cells, both of which have drop down lists for options 'a' & 'b'. When one equals 'a' the other should be restricted into only saying 'b' and vice versa. I would also like the user to be reminded that he can only select 'a' once from the two menus. Ideally I would like to do this in a formula rather than VBA?

Please could someone help!!

Kind regards,

Stumped again on how to create a drop down list box which contains specific data based upon the input of another cell.

Using the attached example; I am trying to create the drop down list box in cell C6 on the OUTPUT DATA worksheet.

I need it to show the loan numbers for the customer whose name and reference number are shown in cells C4 and C5 respectively. Which in this example is Rudolf Reindeer, customer number 758073.

I want the list box to only show the loan numbers that have a balance greater than zero based upon the figures shown in Colum I of the MAIN DATA worksheet.

This would mean that for this customer only 4 of the 6 loan numbers listed in Column E of the MAIN DATA worksheet would be shown in the list box.

598
606
672
861

I have tried searching for a solution on the forum but there does not appear to have been a similar query that I can find.

Hopefully, someone out there will have the answer.

Thanks in advance ...spellbound

Hi,

I am trying to create a drop down in a combobox where only values are displayed from a column that are greater than a date in another cell. I have found a lot of information on creating lists where there is an exact match but cannot find anything on how to do this with a 'greater than' criteria.

Say for example I have a list of names in column A. Column B has dates in it for each name. Cell C1 has a date in it that can change.

In another worksheet I only want the names in Column A to appear in the drop down box where the date in Column B is greater than the date in Cell C1.

Does anyone know how to use Data Validation to achieve this?

Thanks!
janie

How do you let a user add items to a drop down list bown that was created by validation, if the answer they are looking for is not there. I also need it to automatically add that entry to the list box.

Hello.

I'm using Excel 2003.

I have a chart page which contains drop down list boxes.

When clicking on the arrow to drop the list down, the box changes location on the page. It typically shifts a bit to the right or left, but has never shifted up or down. It only seems to move along the horizontal plane.

I have checked the object properties box and compared the settings with other DDL's on the page which don't move. The settings are identical.

I want to stop the DDL from changing locations.

If someone has encountered this and was able to stop it happening, how did you do it?

Any advice is appreciated.


No luck finding an answer? You could always try Google.