How to Lock Table Cell Sizes When Excel for the Web Cannot
Question details
The user needs to create fixed row heights, column widths, and locked worksheet areas in an Excel-compatible workbook while working in Excel for the web.

- Product
- Microsoft Excel for the Web
- Device & OS
- not provided
- Scenario
- The user wants to set exact table cell dimensions and protect selected cells from changes.
- Observed behavior
- Excel for the web only provides basic row and column resizing and does not expose desktop-level worksheet protection or exact layout controls.
Confirm the workbook is closed in the browser and open it in a desktop spreadsheet application before changing row heights, column widths, or worksheet protection.
Use WPS Spreadsheets to Set Fixed Table Cell Sizes and Lock Worksheet Areas
Use this method when you need exact row heights, column widths, and protected cells in an Excel-compatible workbook without relying on Excel for the web.
WPS Spreadsheets is a desktop spreadsheet application that supports Excel .xlsx files and provides the layout and protection controls that Excel for the web does not expose.
Launch WPS Office, click WPS Spreadsheets, then go to Menu > Open and select the workbook from your computer, OneDrive, or SharePoint download.
Select the target rows or columns, right-click the row or column header, choose Row Height or Column Width, and enter the fixed size.
Select the cells users may edit, right-click and choose Format Cells, open the Protection tab, and clear or select Locked as needed.
Go to the Review tab, click Protect Sheet, set the allowed actions and optional password, then click OK to lock the worksheet layout.
Click Menu > Save As and choose .xlsx to keep the fixed cell sizes and protection settings for Excel desktop and WPS Office.

Use Microsoft Excel Desktop to Lock Cell Sizes and Worksheet Protection
Use this route when you are required to stay within Microsoft Excel and have access to the desktop app.
Lock Row Heights, Column Widths, and Worksheet Protection in WPS Spreadsheets
WPS Spreadsheets can directly set exact table cell sizes and worksheet protection in Excel-compatible workbooks, even when Excel for the web cannot provide these controls.
- 1. Launch WPS Spreadsheets: Open WPS Office, select WPS Spreadsheets, and open the target workbook from your computer or cloud storage.
- 2. Set fixed row and column sizes: Select the target rows or columns, right-click the header, choose Row Height or Column Width, and enter the fixed value.
- 3. Adjust locked cell status: Select the cells that should remain editable or locked, open Format Cells > Protection, and set the Locked option as needed.
- 4. Protect the sheet: Click Review > Protect Sheet, choose allowed actions and an optional password, then click OK.
- 5. Save as .xlsx: Click Menu > Save As and select .xlsx to preserve compatibility with Microsoft Excel.

Frequently Asked Questions
Why can't I lock table cell sizes in Excel for the web?
Excel for the web is browser-based and only supports basic row and column resizing. Worksheet protection, locked cells, and exact layout controls require a desktop spreadsheet app such as WPS Spreadsheets or Excel desktop.
Can WPS Spreadsheets open and save the same .xlsx workbook?
Yes. Open the file in WPS Spreadsheets, edit the row heights, column widths, and protection settings, then save as .xlsx. The formatting and protection remain compatible with Excel.
How do I set exact row heights and column widths in WPS Spreadsheets?
Select the target rows or columns, right-click the header, choose Row Height or Column Width, and enter the exact value. Then protect the sheet from the Review tab to prevent changes.
Will worksheet protection still work when the file is opened in Excel desktop?
Yes. WPS Spreadsheets writes standard Excel worksheet protection, so the locked cells and protected layout remain active when the file is opened in Microsoft Excel desktop.
Is WPS Office free to use for this task?
Yes. WPS Office is free to download and use, and WPS Spreadsheets includes the layout and worksheet protection features needed for Excel-compatible workbooks.




