Formatting Issues

Allow AutoFit Row Height on a Protected Excel Worksheet

Olivia MillerOlivia Miller Nov 14, 2026 868 views

Question details

The user wants to AutoFit row heights while working on a protected Excel worksheet.

Allow AutoFit Row Height 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.
Before you start

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.

Solution 1

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.

1
Unprotect the sheet

Open the Review tab, select Unprotect Sheet, and enter the password if prompted.

2
Enable row formatting

Select Review > Protect Sheet, check Format rows in the permissions list, and confirm the protection settings.

3
Test AutoFit

Select the rows, then choose Home > Format > AutoFit Row Height. If the command is unavailable, use the unprotect-and-AutoFit method instead.

Free Microsoft Office alternative

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.

Adjust row heights and other spreadsheet formattingOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar interface for everyday spreadsheet tasksWork with a free, lightweight office suite
microsoft office alternative - wps office

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.