Formatting Issues

How to Fix Incorrect Table Measurements in Word and Excel

Phi Hung VoPhi Hung Vo Oct 28, 2026 874 views

Question details

The user needs to create a table with precise cell dimensions, but the table measurements do not align correctly with the ruler.

How to Fix Incorrect Table Measurements in Word and Excel
Product
Microsoft Word and Excel
Device & OS
not provided
Scenario
Creating a table with exact cell dimensions for precise document formatting or layout requirements.
Observed behavior
The actual dimensions of the table cells do not match the intended measurements due to hidden cell margins, AutoFit settings, or text formatting.
Before you start

Ensure that your document's ruler is visible (View > Ruler) and that your default measurement units are set to your preferred scale (such as inches) in the application's advanced options.

Solution 1Recommended

Adjust Table Properties and Disable AutoFit

Configure exact row heights, remove default cell margins, and lock column widths to ensure precise and static table dimensions.

By default, word processors add small cell margins and use AutoFit to expand cells based on text size. Disabling these automatic adjustments is necessary for creating rigid, exact-sized grid squares.

1
Set Cell Margins to Zero

Select the entire table, right-click, and choose 'Table Properties'. Go to the 'Table' tab, click the 'Options' button, and set all default cell margins (Top, Bottom, Left, Right) to 0.

2
Set Exact Row Height

In the 'Table Properties' dialog, switch to the 'Row' tab. Check the box for 'Specify height', enter your exact measurement (e.g., 0.25"), and change the 'Row height is' dropdown menu from 'At least' to 'Exactly'.

3
Disable AutoFit

With the table still selected, navigate to the 'Layout' tab on the top ribbon. In the 'Cell Size' group, click 'AutoFit' and select 'Fixed Column Width'.

4
Adjust Paragraph Spacing

Select all text or empty space inside the table. Go to the 'Home' tab, open 'Paragraph Settings', and ensure that 'Before' and 'After' spacing are both set to 0 pt, and 'Line spacing' is set to 'Single'.

Adjust Table Properties and Disable AutoFit
Account for Border Thickness: Remember to account for table borders when checking final measurements against the ruler. Thick borders can add slight variations to the overall width and height of the cells.
Precise Table Formatting with WPS Office

Create Perfectly Sized Tables in WPS Office

WPS Office provides highly accurate table formatting tools that make it easy to set exact row heights, column widths, and cell margins without unexpected resizing or formatting glitches.

  1. 1. Insert a Table: Open WPS Writer, navigate to the 'Insert' tab, and click 'Table' to create your grid.
  2. 2. Open Table Properties: Right-click anywhere inside the table and select 'Table Properties' from the context menu.
  3. 3. Set Exact Dimensions: Use the 'Row' and 'Column' tabs to input your exact measurements, setting the row height to 'Exactly'. Adjust cell margins to zero under 'Table' > 'Options'.
Easily set exact row heights and fixed column widths.Intuitive Table Properties dialog for precise cell margin control.Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) table formats.Free, lightweight, and fast office suite for all your documentation needs.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my table cell resize automatically when I type?

This happens because the 'AutoFit to Contents' feature is enabled by default. To stop this behavior, select your table, go to the Layout tab on the ribbon, click AutoFit, and choose 'Fixed Column Width'.

Do table borders affect the exact measurements of my cells?

Yes, border thickness can add extra width and height to your cells. If you need extremely precise measurements, you must factor in the point size of your table borders or remove borders entirely to match the ruler perfectly.

Why is my row height larger than the exact size I specified?

This is typically caused by paragraph spacing or a large font size inside the cell. Ensure that your paragraph spacing (Before and After) is set to 0 pt, line spacing is single, and the font size is small enough to fit within your specified exact height.