All Content
Timespan
explore our new search
Excel Insert Blank Row After Every Two Data Rows #Shorts
Excel
Sep 23, 2022 12:00 AM

Excel Insert Blank Row After Every Two Data Rows #Shorts

by HubSite 365 about MrExcel.com YouTube

Pro UserExcel

LC has 4000 rows of Excel data. After every two rows, he wants to insert a blank row.

How can he quickly insert 2000 blank rows in the data? My solution today involves a formula to create alternating cells with text and numbers. Then Home, Find & Select, Go To Special. Select all Formula cells that result in Text. This selects every other row. You can then Insert Sheet Rows and you are done in less than 60 seconds.

We value your privacy

This website stores data such as cookies to enable important website functions as well as marketing, personalization and analysis. You can change your settings at any time or accept the default settings. privacy policy.