Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
excel drop down list not working
Name: Naffy Date: April 1, 2004 at 14:33:22 Pacific OS: win 98 CPU/Ram: not relevant
Comment:
I'm using office 97 on win 98 and have set up a spreadsheet with quite a lot of calclations, etc going on - it includes data validation from a list with the drop down option selected. However, the drop down arrow does not appear. (The validation is set up pretty much the same as per other sheets which work so it seems to be a bit of a quirk) Anyone got any ideas?
Also, the normal view doesn't work, only page break preview. Again, any ideas?
Summary: OK, I think I was able to duplicate your issue, but it doesn't seem to be consistant. (See below for a possible solution) I'm not sure, but it appears that it is dependent on where your cursor is what...
Summary: I have an Excel sheet that I want to simplify for my users. I want to give them the ability to select data from a drop down and have the sheet prefill other columns based on their dropdown selection....
Summary: Not perhaps the most elegant solution but I got this to work. Enter the names of the car models in seperate columns for each make in a block of cells e.g.A1:E10. Then make a list of the "makes" so tha...