I think I'd sort the data to group those visible cells. Then fill those empty
cells and resort the data to its original order.

I'd have a column that was essentially a row number column.
show all the rows first.
Insert a new column A.
put 1 in A2 and 2 in A3
select a2:a3 and drag down your data.

Filter your data to see the blanks you want to fill.
select that range of visible cells and type in XXXXXX, but hit ctrl-enter to
fill all those selected cells.

Now sort by that column.
filter to show just the XXXXXX's.
All the XXXXXX's will be grouped together and you can fill those cells with what
you want.

Then show all the rows and sort by that column A to put things in their original
order.


Maria wrote:

I want to know continously give a serial number skipping in between some rows
that are filtered.

In excel if we try Fill series, it is not working on filtered rows.

Is there any way out? Please help.

--

Dave Peterson