repeat a group of cells

D

Dearoledad

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
....
 
S

Sean Timmons

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.
 
D

Dearoledad

Your first option was perfect. So simple I should have known to try that.
Thanks.
 

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

Paste with Blank Rows? 2
Macro to add Multiple rows in same sheet 1
SUMPRODUCT to calculate unique occurences of string in column of d 3
Average values for a given rank 3
Finding Next Largest Number Based on Criteria 3
Sum results of VLOOKUP 7
formula to identify specific cells 1
Is there a formula that can do this? 3

Top