Does your Excel spreadsheet resemble Swiss cheese with blank rows everywhere? Here’s a quick tip to shoo those pesky blank rows on mass, keeping your spreadsheets clean and organised.
Why use this tip?
- Locate and interpret data quickly – essential for when reviewing financial records, case timelines or client lists.
- Improve accuracy – by eliminating unnecessary gaps you reduce the risk of errors when using formulas when reviewing large data sets.
- Professional presentation – a well-organised spreadsheet reflects professionalism, whether you’re sharing it with colleagues, clients, or courts.
- Better collaboration – clean, structured data makes it easier for team members to work collaboratively, especially during document-heavy litigation or due diligence.
How to get started
1. Select Ctrl + G to open the ‘Go To’ window.
2. Select ‘Special’.
3. Select ‘Blanks’.
4. Select ‘Ok’
This will select all blank cells and you can then delete them on mass.
