AutoFill Visible Cells with Months

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Elaine - 16 Mar 2005 21:05 GMT

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 this Message

Don Guillett - 16 Mar 2005 21:15 GMT

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

Signature

Don Guillett
SalesAid Software
donaldb@281.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
[quoted text clipped - 9 lines]
> only the visible cells filled so that there are no skipped months where there
> are hidden rows.

Reply to this Message

Elaine - 16 Mar 2005 22:51 GMT

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?

> Jan in cell>select (highlight) cells to
> fill>edit>fill>series>columns>autofill
[quoted text clipped - 16 lines]
> there
> > are hidden rows.

Reply to this Message

Don Guillett - 16 Mar 2005 23:13 GMT

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.

Signature

Don Guillett
SalesAid Software
donaldb@281.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?
[quoted text clipped - 19 lines]
> > there
> > > are hidden rows.

Reply to this Message