Fix Excel Table Row and Column Selection After Sheet Protection
Question details
Restore row and column selection within an Excel table after worksheet protection settings disabled it.

- 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.
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.
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.
Open the affected worksheet and select Review > Unprotect Sheet. Enter the password if prompted.
Select Review > Protect Sheet to open the worksheet protection options.
Check Select locked cells in the list of permitted actions, then confirm the protection settings. Set or enter a password if needed.
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.

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.

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.




