+ Reply to Thread
Results 1 to 3 of 3

How to create identical dropdown lists in large blocks of cells

  1. #1
    Paul
    Guest

    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?

  2. #2
    Anne Troy
    Guest

    Re: How to create identical dropdown lists in large blocks of cells

    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:C38C3E30-EB11-4D4F-B70D-376E58D0B5A2@microsoft.com...
    >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?




  3. #3
    Paul
    Guest

    Re: How to create identical dropdown lists in large blocks of cell

    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:C38C3E30-EB11-4D4F-B70D-376E58D0B5A2@microsoft.com...
    > >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?

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1