How to insert Data in each alternative Row of a table in Excel? - Software Applications - MS Excel - TIK Share

How to insert Data in each alternative Row of a table in Excel?


CA Pulkit Sharma

2014-02-17

To insert the row with data in alternative rows of a table in Excel,

First step is to Insert alternate blank rows in excel table. To insert the blank rows refer How to Insert alternate Blank row in an Excel table?

Once blank rows are inserted in table proceed to second step.

In second step, Filter the blank cells in Table.

How to insert  Data in each alternative Raw of a table in Excel?

 

Third Step is to copy the Data that you want to paste in these rows and Paste the Data.

Once data is pasted Clear the filters. Your table is ready!!!

How to insert  Data in each alternative Raw of a table in Excel?

 

For any doubts please feel free to ask!!!