Document Editing Problems

Fix Excel Table Row and Column Selection After Sheet Protection

Emma BrownEmma Brown Nov 14, 2026 868 views

Question details

Restore row and column selection within an Excel table after worksheet protection settings disabled it.

Fix Excel Table Row and Column Selection After Sheet Protection
Product
Microsoft Excel
Device & OS
not provided
Scenario
A worksheet containing an Excel table was protected with Select Locked Cells disabled and then unprotected.
Observed behavior
Selecting rows or columns within the table stopped working and remained unavailable after the sheet was unprotected.
Before you start

Confirm that the problem affects rows or columns within an Excel table, rather than entire worksheet rows or columns. If the sheet is currently protected, have its password available if one was set.

Solution 1Recommended

Reprotect the Excel sheet with Select Locked Cells enabled

Use this workaround when table selection remains unavailable after a sheet was protected with locked-cell selection disabled.

1
Unprotect the sheet if needed

Open the affected worksheet and select Review > Unprotect Sheet. Enter the password if prompted.

2
Open protection settings

Select Review > Protect Sheet to open the worksheet protection options.

3
Allow locked-cell selection

Check Select locked cells in the list of permitted actions, then confirm the protection settings. Set or enter a password if needed.

4
Test the table selection

Move the pointer to the top edge of a table column or the left edge of a table row, then click when the selection arrow appears. Check that the table column or row can be selected.

Reprotect the Excel sheet with Select Locked Cells enabled
Worksheet protection remains enabled: This workaround restores table selection by protecting the sheet again with Select locked cells enabled. Other protection permissions remain subject to the options you choose.
Free Microsoft Office alternative

Work with Excel tables in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and continue editing in WPS Spreadsheets; it does not repair the Excel protection issue.

Open and edit Microsoft Excel XLSX and XLS filesWork with spreadsheet rows, columns, and table dataUse a familiar interface to make migration easierInstall a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why can't I select a row or column in my Excel table?

The issue can occur after a worksheet is protected with Select locked cells cleared, even after it is unprotected. Try Review > Protect Sheet and enable Select locked cells.

Does this issue affect entire worksheet rows?

The reported issue concerns selecting rows or columns within an Excel table, not selecting entire worksheet rows or columns.

Do I need the worksheet password to change protection settings?

If the sheet is already protected with a password, select Review > Unprotect Sheet and enter the password before changing its protection settings.

How can I report the issue to Microsoft?

Record a video showing the table selection issue and capture the Excel account information from File > Account. Remove private information, then submit the details through Excel's feedback option, such as File > Feedback.