How to lock columns and rows in a table

September 28, 2021
1,362 Views 0

1. Use WPS Office to open the table.

2. Click the Review tab  and then click the Lock Cell button.

3. Now click the Protect Sheet button, then the Protect Sheet box will pop up. Uncheck Insert Columns and Insert Rows.

4. Now we will find it impossible to insert rows and columns in this table.

How to lock columns and rows in table.gif

This skill could be also used in Microsoft Office Excel and Openoffice.

Was this helpful?