How to lock columns and rows in a table

September 28, 2021
95 Views 0

Graphic skills

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.