blocks of data repeating

E

eween

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?
 
T

Trevor Shuttleworth

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
 
E

eween

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

Gord Dibben

Do you have calculation set to manual perhaps?

Tools>Options>Calculation. Checkmark "Automatic".


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

Adding data to MS Access from csv file 0
Cell data entering slow! 0
S.Y.M. Wong-A-Ton .... PLEASE HELP, I Need your INFOPATH 2013 COOKBOOK 2 1
Need Help with a VBA subroutine 0
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
Rows to repeat at top 3
Split cells next to 1 cell 1
Macro to Compile Data from Different Sheets 2

Top