|
|
#1
08-09-2022, 04:27 PM
|
|||
|
|||
Deleting Multiple Rows
I copied over a list to excel which has data in row 1, then row 2 and 3 are blank, and data in row 4. This goes on for about 2000 rows. How do I quickly delete the 2 rows that are blank in between the cells that contain data?
Looks like this... 123 blank blank 456 blank blank 789 blank blank 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Deleting rows
|
lourid | Excel Programming | 5 | 03-15-2022 09:39 AM |
| VBA - Deleting Rows (criteria based) | BobbyG | Project | 1 | 07-31-2017 08:55 AM |
|
Deleting rows with partially redundant data
|
Noah14 | Excel Programming | 1 | 09-19-2014 11:46 PM |
| Deleting rows & pushing them up causing issues | ep2002 | Excel | 2 | 08-29-2014 02:09 AM |
|
Deleting rows with specific criteria
|
joflow21 | Excel | 9 | 11-22-2013 12:10 PM |
Windows 10 
Office 2019
Threaded Mode