Assist Pro+ / Templates and Present

Hide All Formulas

Hide All Formulas / NB! - Unprotect Sheet to undo.

Where to find it

Follow the ribbon path.

Assist Pro + → Templates and Present → Other → More → Review Security → Hide All Formulas

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 tools

Practical guidance

Use this tool in your workflow.

How to use

Prepare and select the relevant range, worksheet or table in the intended workbook. On Assist Pro + › Templates and Present › Other › More › Review Security, choose Hide All Formulas to hide All Formulas / NB! - Unprotect Sheet to undo. Inspect the output and save the workbook after confirming it looks right.

Best use case

Useful when polishing a worksheet for review or reporting and you need to hide All Formulas / NB! - Unprotect Sheet to undo.

Everyday Excel

Speeds preparing clean, readable report layouts when you need to hide All Formulas / NB! - Unprotect Sheet to undo.

Accounting and audit

Improves workpaper presentation and reviewer readability by helping hide All Formulas / NB! - Unprotect Sheet to undo.