blocks of data repeating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
That isnt it. and it is just columns D - G rows 1-7 that are repeating over
and over again...
 
Do you have calculation set to manual perhaps?

Tools>Options>Calculation. Checkmark "Automatic".


Gord Dibben MS Excel MVP
 
Back
Top