+ Reply to Thread
Results 1 to 4 of 4

AutoFill Visible Cells with Months

  1. #1
    Elaine
    Guest

    AutoFill Visible Cells with Months

    I would like to type Jan in A2 and AutoFill up to however far the selection
    goes. However, there are some rows that are hidden. I am not able to autofill
    the visible cells in the selection.

    What I have done is:
    Type Jan in A2
    Select area to be filled
    Select visible cells (by pressing F5 and clicking Special Cells)
    EDIT | Fill | Series | Autofill

    I get some weird results. Can anyone please help me get Jan, Feb etc with
    only the visible cells filled so that there are no skipped months where there
    are hidden rows.

  2. #2
    Don Guillett
    Guest

    Re: AutoFill Visible Cells with Months

    Jan in cell>select (highlight) cells to
    fill>edit>fill>series>columns>autofill
    worked for me.

    --
    Don Guillett
    SalesAid Software
    donaldb@281.com
    "Elaine" <Elaine@discussions.microsoft.com> wrote in message
    news:6CB34156-C6CA-45DD-A802-B723F0CF2216@microsoft.com...
    > I would like to type Jan in A2 and AutoFill up to however far the

    selection
    > goes. However, there are some rows that are hidden. I am not able to

    autofill
    > the visible cells in the selection.
    >
    > What I have done is:
    > Type Jan in A2
    > Select area to be filled
    > Select visible cells (by pressing F5 and clicking Special Cells)
    > EDIT | Fill | Series | Autofill
    >
    > I get some weird results. Can anyone please help me get Jan, Feb etc with
    > only the visible cells filled so that there are no skipped months where

    there
    > are hidden rows.




  3. #3
    Elaine
    Guest

    Re: AutoFill Visible Cells with Months

    Don, I still couldn't get it. I want to get the months for the visible cells.
    If there are hidden rows, the months skip. Is that not so?

    "Don Guillett" wrote:

    > Jan in cell>select (highlight) cells to
    > fill>edit>fill>series>columns>autofill
    > worked for me.
    >
    > --
    > Don Guillett
    > SalesAid Software
    > donaldb@281.com
    > "Elaine" <Elaine@discussions.microsoft.com> wrote in message
    > news:6CB34156-C6CA-45DD-A802-B723F0CF2216@microsoft.com...
    > > I would like to type Jan in A2 and AutoFill up to however far the

    > selection
    > > goes. However, there are some rows that are hidden. I am not able to

    > autofill
    > > the visible cells in the selection.
    > >
    > > What I have done is:
    > > Type Jan in A2
    > > Select area to be filled
    > > Select visible cells (by pressing F5 and clicking Special Cells)
    > > EDIT | Fill | Series | Autofill
    > >
    > > I get some weird results. Can anyone please help me get Jan, Feb etc with
    > > only the visible cells filled so that there are no skipped months where

    > there
    > > are hidden rows.

    >
    >
    >


  4. #4
    Don Guillett
    Guest

    Re: AutoFill Visible Cells with Months

    You said "no skipped months where there are hidden cells"
    If you followed what I said and the second row was hidden you would get

    Jan
    Mar
    Apr

    showing.


    --
    Don Guillett
    SalesAid Software
    donaldb@281.com
    "Elaine" <Elaine@discussions.microsoft.com> wrote in message
    news:5864EA72-17D2-4888-B624-D6FBDDBFC6E9@microsoft.com...
    > Don, I still couldn't get it. I want to get the months for the visible

    cells.
    > If there are hidden rows, the months skip. Is that not so?
    >
    > "Don Guillett" wrote:
    >
    > > Jan in cell>select (highlight) cells to
    > > fill>edit>fill>series>columns>autofill
    > > worked for me.
    > >
    > > --
    > > Don Guillett
    > > SalesAid Software
    > > donaldb@281.com
    > > "Elaine" <Elaine@discussions.microsoft.com> wrote in message
    > > news:6CB34156-C6CA-45DD-A802-B723F0CF2216@microsoft.com...
    > > > I would like to type Jan in A2 and AutoFill up to however far the

    > > selection
    > > > goes. However, there are some rows that are hidden. I am not able to

    > > autofill
    > > > the visible cells in the selection.
    > > >
    > > > What I have done is:
    > > > Type Jan in A2
    > > > Select area to be filled
    > > > Select visible cells (by pressing F5 and clicking Special Cells)
    > > > EDIT | Fill | Series | Autofill
    > > >
    > > > I get some weird results. Can anyone please help me get Jan, Feb etc

    with
    > > > only the visible cells filled so that there are no skipped months

    where
    > > there
    > > > are hidden rows.

    > >
    > >
    > >




+ 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