N
N
Hi, does anyone here know how I can set up a drop down
list in Excel 1997 so that it automatically repeats down
the column?
list in Excel 1997 so that it automatically repeats down
the column?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Ken Wright
Select the entire range, then create the dropdown list using Data / Validation / List......
N
N
The problem is that I have an older version of Excel that
doesn't give me the Validation option when I press data.
Is there any other way to go about doing that?
doesn't give me the Validation option when I press data.
Is there any other way to go about doing that?
using Data / Validation / List......-----Original Message-----
Select the entire range, then create the dropdown list
N
N
Actually, I think my Excel is an older version so it
doesn't give me the "Validation" option when I press the
Data button. Do you know if there is any other way to do
this?
Thanks
doesn't give me the "Validation" option when I press the
Data button. Do you know if there is any other way to do
this?
Thanks
A
Arvi Laanemets
Hi
When you never used this feature before, it's hidden. Activate Data
from menu. When there is a double-arrow at bottom of dropdown, it
activated hidden features.
When this is not the case, then probably its removed somehow. You can
return it from View.Toolbars.Customize.Commands
Arvi Laanemets
When you never used this feature before, it's hidden. Activate Data
from menu. When there is a double-arrow at bottom of dropdown, it
activated hidden features.
When this is not the case, then probably its removed somehow. You can
return it from View.Toolbars.Customize.Commands
Arvi Laanemets