Office Settings & Configuration

Restore Pixel Measurements When Resizing Rows and Columns in Excel

Tauseeq MagsiTauseeq Magsi Nov 12, 2026 869 views

Question details

The user wants Excel to show pixel-based measurements again while resizing worksheet rows or columns.

Restore Pixel Measurements When Resizing Rows and Columns in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user is adjusting row heights or column widths and needs the resize measurement display to appear.
Observed behavior
Excel no longer shows the expected pixel measurement while a row or column boundary is dragged; the available measurement can vary by Excel version and worksheet view.
Before you start

Open the affected workbook in the same Excel version where the measurement behavior changed. Make sure the worksheet is in a standard editable view and set the zoom to a normal level, such as 100%, before testing row or column resizing.

Solution 1Recommended

Check Excel view, zoom, and display settings

Use this first when the resize tooltip or measurement display disappeared after a view or interface change.

Excel can display different sizing information depending on the active worksheet view, zoom level, and version. The resize measurement is typically shown only while you drag a row or column boundary.

1
Switch to Normal view

In Excel, select the View tab, then choose Normal in the Workbook Views group. Return to the worksheet and drag a column divider or row divider to check the measurement display.

2
Set a standard zoom level

Use the zoom slider in the lower-right corner of the Excel window, or select View > Zoom, and set the worksheet to 100%. Drag a row or column boundary again.

3
Review status bar options

Right-click an empty area of the Excel status bar at the bottom of the window and verify that relevant display options are enabled. Then resize a row or column while watching for the sizing tooltip.

4
Check the active worksheet mode

On the View tab, leave Page Layout or Page Break Preview if those views do not show the expected measurement. Select Normal, then drag the boundary between two column letters or row numbers.

Check Excel view, zoom, and display settings
Measurement formats can differ: Excel may show column width in characters and row height in points rather than pixels. The exact resize indicator depends on the Excel build, zoom, display scaling, and worksheet view.
Free Microsoft Office alternative

Edit Excel Workbooks Easily with WPS Spreadsheet

If Excel's interface behavior remains unavailable or varies by version, WPS Office provides a free, lightweight spreadsheet alternative with familiar row and column resizing controls. Open, edit, and save your existing workbooks with a familiar ribbon-based workspace and migrate your spreadsheet tasks seamlessly.

Resize rows and columns directly from worksheet headers in WPS Spreadsheet.Open and edit Microsoft Excel .xlsx, .xls, and .csv files.Use a familiar spreadsheet interface for a smooth transition from Excel.Work with a free, lightweight office suite for everyday spreadsheet editing.
QA img-9

Frequently Asked Questions

Why does Excel show column width instead of pixels?

Excel commonly uses character-based width for columns and point-based height for rows. Pixel-related resize information, when available, can vary by Excel version, zoom, screen scaling, and the active worksheet view.

Which Excel view should I use to check row and column resize measurements?

Select View > Normal. Then drag the boundary between column letters or row numbers. Page Layout and Page Break Preview can present sizing information differently.

Can Excel add-ins prevent resize measurements from appearing?

Yes. Test Excel in Safe Mode by pressing Windows+R, entering excel /safe, and selecting OK. If the display returns, disable add-ins through File > Options > Add-ins and test them individually.

How do I repair Excel if its display options are not working correctly?

Go to Windows Settings > Apps > Installed apps, locate Microsoft 365 or Microsoft Office, select More options > Modify, and run Quick Repair. Use Online Repair if Quick Repair does not resolve the problem.

Does changing zoom affect Excel row and column measurement displays?

It can. Set the worksheet to 100% using the zoom slider in the lower-right corner or View > Zoom, then test the measurement while dragging a row or column boundary.