WPS Office
Free All-in-One Office Suite with PDF Editor
Edit Word, Excel, and PPT for FREE.
Read, edit, and convert PDFs with the powerful PDF toolkit.
Microsoft-like interface, easy to use.
Free download
Windows • MacOS • Linux • iOS • Android
How to lock columns and rows in a table
June 8, 2023
17.1K
Views
52
1. Use WPS Office to open the table.
2. Click theReview tab →and then click the Lock Cellbutton.
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.
This skill could be also used in Microsoft Office Excel and Openoffice.