blocks of data repeating
 

I have entered data into a sheet and just went back to it to find that
several rows are repeating over and over and the data I entered in row 8 on
contain the info from rows 1 - 7 over and over again. Can someone tell me
what I did?

blocks of data repeating
 

Sounds like you might have selected the data in rows 1 to 7 and then dragged
down on the AutoFill handle ... the bottom right of a cell where the cursor
turns to a fine cross-hair (plus sign)

Regards

Trevor


"eween" wrote in message
...
I have entered data into a sheet and just went back to it to find that
several rows are repeating over and over and the data I entered in row 8
on
contain the info from rows 1 - 7 over and over again. Can someone tell me
what I did?

blocks of data repeating
 

That isnt it. and it is just columns D - G rows 1-7 that are repeating over
and over again...

"Trevor Shuttleworth" wrote:

Sounds like you might have selected the data in rows 1 to 7 and then dragged
down on the AutoFill handle ... the bottom right of a cell where the cursor
turns to a fine cross-hair (plus sign)

Regards

Trevor


"eween" wrote in message
...
I have entered data into a sheet and just went back to it to find that
several rows are repeating over and over and the data I entered in row 8
on
contain the info from rows 1 - 7 over and over again. Can someone tell me
what I did?

blocks of data repeating
 

Do you have calculation set to manual perhaps?

ToolsOptionsCalculation. Checkmark "Automatic".


Gord Dibben MS Excel MVP

On Thu, 29 Mar 2007 09:20:04 -0700, eween
wrote:

That isnt it. and it is just columns D - G rows 1-7 that are repeating over
and over again...

"Trevor Shuttleworth" wrote:

Sounds like you might have selected the data in rows 1 to 7 and then dragged
down on the AutoFill handle ... the bottom right of a cell where the cursor
turns to a fine cross-hair (plus sign)

Regards

Trevor


"eween" wrote in message
...
I have entered data into a sheet and just went back to it to find that
several rows are repeating over and over and the data I entered in row 8
on
contain the info from rows 1 - 7 over and over again. Can someone tell me
what I did?

blocks of data repeating
 

set to auto

"Gord Dibben" wrote:

Do you have calculation set to manual perhaps?

ToolsOptionsCalculation. Checkmark "Automatic".


Gord Dibben MS Excel MVP

On Thu, 29 Mar 2007 09:20:04 -0700, eween
wrote:

That isnt it. and it is just columns D - G rows 1-7 that are repeating over
and over again...

"Trevor Shuttleworth" wrote:

Sounds like you might have selected the data in rows 1 to 7 and then dragged
down on the AutoFill handle ... the bottom right of a cell where the cursor
turns to a fine cross-hair (plus sign)

Regards

Trevor


"eween" wrote in message
...
I have entered data into a sheet and just went back to it to find that
several rows are repeating over and over and the data I entered in row 8
on
contain the info from rows 1 - 7 over and over again. Can someone tell me
what I did?