Unmerge cells and remove blank rows and columns.
Assist Pro + → Find / Quick Access → Clean Data
Part of Assist Pro+. Eligible tools can also be selected through Assist Pro’s 30-tool Vault allowance. Check the Vault for availability.
Open the tool and follow its prompts. Use a copy of your workbook when trying an action for the first time, then check the result.
Browse all toolsOpen the Excel workbook in which you want to use the command. On Assist Pro + › Find / Quick Access, choose Clean Data to unmerge cells and remove blank rows and columns. Confirm the target workbook or selected cells before rerunning a saved action.
Preparing a messy imported table with merged cells and empty rows or columns.
Reduces repeated clicks and manual edits in everyday spreadsheets when you need to unmerge cells and remove blank rows and columns.
Speeds preparing working-paper schedules and client exports when you need to unmerge cells and remove blank rows and columns.