Office Compatibility Issues

How to Lock Table Cell Sizes When Excel for the Web Cannot

John WilsonJohn Wilson Nov 13, 2026 869 views

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.

How to Lock Table Cell Sizes When Excel for the Web Cannot
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the workbook in WPS Spreadsheets

Launch WPS Office, click WPS Spreadsheets, then go to Menu > Open and select the workbook from your computer, OneDrive, or SharePoint download.

2
Set exact row heights and column widths

Select the target rows or columns, right-click the row or column header, choose Row Height or Column Width, and enter the fixed size.

3
Control which cells remain locked

Select the cells users may edit, right-click and choose Format Cells, open the Protection tab, and clear or select Locked as needed.

4
Enable worksheet protection

Go to the Review tab, click Protect Sheet, set the allowed actions and optional password, then click OK to lock the worksheet layout.

5
Save in Excel-compatible format

Click Menu > Save As and choose .xlsx to keep the fixed cell sizes and protection settings for Excel desktop and WPS Office.

Use WPS Spreadsheets to Set Fixed Table Cell Sizes and Lock Worksheet Areas
Layout and protection applied: The exact row heights, column widths, and locked cells are now stored in the workbook and remain active when the file is opened in WPS Office or Excel desktop.

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. 1. Launch WPS Spreadsheets: Open WPS Office, select WPS Spreadsheets, and open the target workbook from your computer or cloud storage.
  2. 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. 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. 4. Protect the sheet: Click Review > Protect Sheet, choose allowed actions and an optional password, then click OK.
  5. 5. Save as .xlsx: Click Menu > Save As and select .xlsx to preserve compatibility with Microsoft Excel.
Set exact row heights and column widths for fixed table cell sizesProtect worksheet cells and ranges without switching to desktop ExcelOpens and saves .xlsx workbooks with full Microsoft Excel format compatibilityFree, lightweight Office suite with a familiar spreadsheet interfaceNo subscription required for advanced layout and protection features
microsoft office alternative - wps office

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.