Note: The other languages of the website are Google-translated. Back to English
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Thursday, 17 February 2022
  1 Replies
  2.2K Visits
Hi, I want to know if the software can do the following:
I have an excel with 4000 rows by 31 columns.
I want to show each row exactly twice.
In other words, have 2 identical rows one after the next instead of just one.
Please let me know if this is something the software can do and I can go ahead and purchase it?
11 months ago
Hi tcdm,

Yes, there is a feature called Duplicate Rows / Rows Based On Cell Value

Please do as follows:

1. Click Kutools > Insert > Duplicate Rows / Columns based on cell value to enable the utility.
2. In the Copy and insert rows & columns dialog, you need to:

  • Select the Copy and insert rows option in the Type section;
  • Select the range you will duplicate the rows in the Insert Range box;
  • Type 1 in the Repeat Times box;
  • Click the OK or Apply button. See screenshot:

  duplicate rows 1.png  
duplicate rows 2.png

If you have any other questions, please don't hesitate to ask me.

  • Page :
  • 1
There are no replies made for this post yet.

Follow Us

Copyright © 2009 - | All rights reserved. Powered by ExtendOffice. | Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Protected by Sectigo SSL