Insert a blank row into every other row for selected list?

[paulwass]

I am selecting 20 rows, and I want to insert a blank row in between each of them. How can I do this?

Thanks,

P

(using excel 2000)

 

[krishnap2w2]

Re: Insert a blank row into every other row for selected lis

Dependent dropdown list is something that keeps-on changing its items based on a change in the value of another dropdown.


Execute the following steps to create these dependent dropdown lists.


1 Name the range A1:A3 as Food.
2 Name the range B1:B4 as Fruits.
3 Name the range C1:C4 as Vegetables.
4 Name the range D1:D3 as Meat.
5 Select cell D3 and go to Data Validation menu in the Data tab and click on Data Validation.
6 In the Data Validation window, select “List” from the dropdown.
7 In the source section, type “=Food” and click on OK button.
8 Select the cell G3 and go to Data Validation menu in the Data tab and click on Data Validation and repeat step 6.
In the source section, type “=INDIRECT(D3)” and click on OK button.

 

[economagicman]

Re: Insert a blank row into every other row for selected lis

Worked perfectly for me on 2016!