| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
repeat a group of cells
How can I repeat a group of values down hundres of rows?
A1= apples A2= cherries A3= pears A4= apples A5= cherries A6= pears A7= apples A8= cherries A9= pears .... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
repeat a group of cells
Two options.
Enter the values once, highlight these three cells, then use the fill handle bar at bottom right to drag down. OR enter three cells, in A4, enter =A1 and copy just this cell to bottom. Copy and paste special/values when done. "Dearoledad" wrote: How can I repeat a group of values down hundres of rows? A1= apples A2= cherries A3= pears A4= apples A5= cherries A6= pears A7= apples A8= cherries A9= pears ... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
repeat a group of cells
Your first option was perfect. So simple I should have known to try that.
Thanks. "Sean Timmons" wrote: Two options. Enter the values once, highlight these three cells, then use the fill handle bar at bottom right to drag down. OR enter three cells, in A4, enter =A1 and copy just this cell to bottom. Copy and paste special/values when done. "Dearoledad" wrote: How can I repeat a group of values down hundres of rows? A1= apples A2= cherries A3= pears A4= apples A5= cherries A6= pears A7= apples A8= cherries A9= pears ... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
repeat a group of cells
Sometime we overthink. :-)
"Dearoledad" wrote: Your first option was perfect. So simple I should have known to try that. Thanks. "Sean Timmons" wrote: Two options. Enter the values once, highlight these three cells, then use the fill handle bar at bottom right to drag down. OR enter three cells, in A4, enter =A1 and copy just this cell to bottom. Copy and paste special/values when done. "Dearoledad" wrote: How can I repeat a group of values down hundres of rows? A1= apples A2= cherries A3= pears A4= apples A5= cherries A6= pears A7= apples A8= cherries A9= pears ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Repeat same data entry to multiple worksheets without Group Functi | Excel Discussion (Misc queries) | |||
| How do I repeat a group of rows at the bottom of each page in Exce | Excel Discussion (Misc queries) | |||
| Repeat group names on each page | Excel Discussion (Misc queries) | |||
| List a group of repeated data from sheet1 to sheet2 but not repeat | New Users to Excel | |||
| Pivot table reports - repeat the group name on each line | Excel Discussion (Misc queries) | |||
Hybrid Mode
