Assist Pro+ / Find / Quick Access

Smart Sheet Fit

Automatically fit rows and columns.

Where to find it

Follow the ribbon path.

Assist Pro + → Find / Quick Access → Smart Sheet Fit

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

Open the Excel workbook in which you want to use the command. On Assist Pro + › Find / Quick Access, choose Smart Sheet Fit to automatically fit rows and columns. Confirm the target workbook or selected cells before rerunning a saved action.

Best use case

Making a wide worksheet or report readable after importing data.

Everyday Excel

Reduces repeated clicks and manual edits in everyday spreadsheets when you need to fit rows and columns.

Accounting and audit

Speeds preparing working-paper schedules and client exports when you need to fit rows and columns.