Remove all formatting from the selection.
Assist Pro + → Templates and Present → Other → Clear Formatting
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 toolsPrepare and select the relevant range, worksheet or table in the intended workbook. On Assist Pro + › Templates and Present › Other, choose Clear Formatting to remove all formatting from the selection. Inspect the output and save the workbook after confirming it looks right.
Removing unwanted source formatting before standardising a report.
Speeds preparing clean, readable report layouts when you need to remove all formatting from the selection.
Improves workpaper presentation and reviewer readability by helping remove all formatting from the selection.