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!!!

Posted 2 years, 11 months ago by CA Pulkit Sharma


No response yet, be first to reply.

Your Reply:

You need to be logged in to reply.