Prev: how do I sumif on a font color in excel 2007?
Next: HOW CAN I IMPLEMENT SUMIF(D1:D6,">AVERAGE(D1:D6)")
From: Doug on 27 Jan 2010 11:56
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
From: Gord Dibben on 27 Jan 2010 14:33
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 <Doug(a)discussions.microsoft.com>
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

 | 
Pages: 1
Prev: how do I sumif on a font color in excel 2007?
Next: HOW CAN I IMPLEMENT SUMIF(D1:D6,">AVERAGE(D1:D6)")