| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
exclude certain cells from series fill
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
exclude certain cells from series fill
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 On Wed, 27 Jan 2010 08:56:12 -0800, Doug wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How fill cells with alpha series? | Excel Discussion (Misc queries) | |||
| How to exclude dates which equal SUNDAY from a fill series? | Excel Worksheet Functions | |||
| auto fill series between to non-adjacent cells | Excel Discussion (Misc queries) | |||
| How to fill cells with a different kind of series? | Excel Worksheet Functions | |||
| how do i fill down a series of linked cells | Excel Discussion (Misc queries) | |||
Linear Mode
