exclude certain cells from series fill

D

Doug

I have a list of files, and I've filled a column to number the files. i want
to insert some rows to act as headers to group these files, but I still want
to keep the numbered list, in order to keep up the the number of files. Can
I fill the column with a series of numbers but exclude the 'header' rows and
cells? TIA
 
G

Gord Dibben

Fill 1 to 100 down column A

File names in Column B

Insert rows for your "headers" where you want.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Series fill only copying and fill series greyed out 1
Fill Series 1
exclude non numbers 2
Formula for function/argument "exclude". 0
Fill date series in table 2
Auto-update row numbers after inserting new row 5
Copied Cells do not run Series consecutively... 3
How to exclude dates which equal SUNDAY from a fill series? 8

Top