CODEWITHSUNDEEP
excelexcel-formula
Chetan Singh
Chetan Singh

Reputation: 47

Excel fill down column with multiple values

I have a excel spread sheet in which values in a column are as under:

Unit
Type
Sex

I want this value to be filled down in column as:

Unit
Type
Sex
Unit
Type
Sex
Unit
Type
Sex

Would be grateful for any help by the experts.

Upvotes: 0

Views: 1351

Answers (2)

deefff
deefff

Reputation: 343

Just type in once, select all three values and drag down the auto-filler (small rectangle in right bottom corner of selection).

If you want to fill up a column up to the same number of rows that is present in a neighboring column, then double-click on the auto-filler.

Upvotes: 1

CallumDA
CallumDA

Reputation: 12113

Another method is the following: if your data is in A1:A3 then just type 

=A1

Into cell A4 and drag down/fill down

Upvotes: 1

Related Questions