View Single Post
Old 08-10-2022, 01:53 AM
rollis13's Avatar
rollis13 rollis13 is offline Windows 10 Office 2016
Competent Performer
Join Date: Jan 2021
Location: Cordenons
Posts: 133
rollis13 will become famous soon enough

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)
Reply With Quote