|
|
#2
08-10-2022, 01:53 AM
|
||||
|
||||
Try this on a test file since the result depends on what data you have in your sheet (no blanks in data rows):
- press key F5 and click 'Special...' (or Go To Special from menu Home / Find & Select dropdown) - select 'Blanks' - OK - use 'Delete Sheet Rows' (from menu Home / Delete dropdown) 
|
| Thread Tools | |
| Display Modes | |
|
|
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 2016
Threaded Mode