| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Relocating reference numbers for many blocks of data | Excel Discussion (Misc queries) | |||
| averaging particular blocks of data | Excel Discussion (Misc queries) | |||
| Copy Blocks Of Data | Excel Discussion (Misc queries) | |||
| How do I repeatedly transpose blocks of data? | Excel Discussion (Misc queries) | |||
| Moving blocks of data in excel | Excel Discussion (Misc queries) | |||
Linear Mode
