How to create identical dropdown lists in large blocks of cells

I use an excel spreadsheet to create a 4 week schedule for 20 nurses. They
work a total of 13 differant shifts. (7a-11a, 7a-3p, 7a-7p, 11a-3p, 11a-7p,
etc).

I'm looking for a way to create identical drop down boxes with a list of the
available shifts for a large group of cells.

So far, I have to do each cell individually via the "Data, Validation, List"
route. That's over 550 individual cells I'd have to program one at a time,
which is just not gonna happen. Anybody have a faster way?

Paul: You can select as many cells as you like when creating a drop-down.
You can also use the Format painter to "re-use" one that already exists.
http://www.officearticles.com/misc/f...oft_office.htm Of
course, I may have misunderstood the problem.
************
Anne Troy
www.OfficeArticles.com

"Paul" <Paul @discussions.microsoft.com> wrote in message
news:[email protected]...
>I use an excel spreadsheet to create a 4 week schedule for 20 nurses. They
> work a total of 13 differant shifts. (7a-11a, 7a-3p, 7a-7p, 11a-3p,
> 11a-7p,
> etc).
>
> I'm looking for a way to create identical drop down boxes with a list of
> the
> available shifts for a large group of cells.
>
> So far, I have to do each cell individually via the "Data, Validation,
> List"
> route. That's over 550 individual cells I'd have to program one at a time,
> which is just not gonna happen. Anybody have a faster way?

I'll try that. Thanks Anne. I'm not familiar with the format painter, but it
sounds like what I need.

"Anne Troy" wrote:

> Paul: You can select as many cells as you like when creating a drop-down.
> You can also use the Format painter to "re-use" one that already exists.
> http://www.officearticles.com/misc/f...oft_office.htm Of
> course, I may have misunderstood the problem.
> ************
> Anne Troy
> www.OfficeArticles.com
>
> "Paul" <Paul @discussions.microsoft.com> wrote in message
> news:[email protected]...
> >I use an excel spreadsheet to create a 4 week schedule for 20 nurses. They
> > work a total of 13 differant shifts. (7a-11a, 7a-3p, 7a-7p, 11a-3p,
> > 11a-7p,
> > etc).
> >
> > I'm looking for a way to create identical drop down boxes with a list of
> > the
> > available shifts for a large group of cells.
> >
> > So far, I have to do each cell individually via the "Data, Validation,
> > List"
> > route. That's over 550 individual cells I'd have to program one at a time,
> > which is just not gonna happen. Anybody have a faster way?
>
>
>