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
 
set to auto

Gord Dibben said:
Do you have calculation set to manual perhaps?

Tools>Options>Calculation. Checkmark "Automatic".


Gord Dibben MS Excel MVP
Click to expand...
 
You must log in or register to reply here.

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

Excel Vertical to horizontal repeat after 16 rows 3
Rows to repeat at top 3
Excel Help to copy information from one row at a time to another sheet 1
copy data from master sheet new 2
copy data from master sheet 6
Sort behaves unexpectedly 1
Excel Drag autofill only part of formula 3
I am using Office 2000 Premium. 1

Back
Top