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? 3
Macro to add Multiple rows in same sheet 1
How to delete ALL cells containing the same data 0
SUMPRODUCT to calculate unique occurences of string in column of d 3
How to delete ALL cells containing the same data --- REVISED 0
Finding Next Largest Number Based on Criteria 3
Average values for a given rank 3
Validation list based on criteria 0

Top