Allow AutoFit Row Height on a Protected Excel Worksheet
Question details
The user wants to AutoFit row heights while working on a protected Excel worksheet.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Users need to adjust row heights to fit cell contents without losing worksheet protection.
- Observed behavior
- Users can format rows on the protected sheet, but Format > AutoFit Row Height is unavailable.
Check whether you have permission to unprotect the sheet and, if required, have its password. Note the existing protection permissions so you can restore them afterward.
Check the Format Rows Permission
Enable row formatting and check whether AutoFit is available in your version of Excel.
The Format rows permission allows certain row-formatting changes, but it may not make AutoFit Row Height available while the sheet is protected.
Open the Review tab, select Unprotect Sheet, and enter the password if prompted.
Select Review > Protect Sheet, check Format rows in the permissions list, and confirm the protection settings.
Select the rows, then choose Home > Format > AutoFit Row Height. If the command is unavailable, use the unprotect-and-AutoFit method instead.
Unprotect the Worksheet to AutoFit Rows
Use this method when AutoFit remains unavailable on the protected sheet.
Edit and Format Spreadsheets with WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and continue editing them in WPS Spreadsheets for an easy transition.

Frequently Asked Questions
Why is AutoFit Row Height unavailable on my protected sheet?
Excel may disable AutoFit while worksheet protection is active, even when Format rows is permitted. Select Review > Unprotect Sheet, apply Home > Format > AutoFit Row Height, and protect the sheet again.
How do I let users change row heights on a protected worksheet?
Unprotect the sheet, select Review > Protect Sheet, and check Format rows before confirming. This permits row formatting, although AutoFit may still be unavailable.
What if I don't know the worksheet protection password?
Ask the workbook owner for the password or for an unprotected copy. You need permission to use Review > Unprotect Sheet when the sheet is password-protected.
Why didn't AutoFit adjust a row containing merged cells?
Excel AutoFit may not work as expected for merged cells. Consider unmerging the cells or setting the row height manually through Home > Format > Row Height.





