Formatting Issues

How to Fix Numbers Displaying Vertically in Excel

Tauseeq Magsi Sep 25, 2026 870 views

Question details

Users are encountering an issue where numeric data entered into a spreadsheet cell displays vertically and incorrectly expands the row height, while standard text continues to display horizontally.

How to Fix Numbers That Display Vertically in an Excel Spreadsheet

Product: Excel
Device & OS: not provided
Scenario: Entering or formatting numeric values in a spreadsheet.
Observed behavior: Numbers appear stacked vertically, causing the row height to increase significantly. Text entered in the same or adjacent cells displays normally, indicating potential workbook corruption or a specific cell formatting error.

Before you start

Verify if the issue is isolated to specific cells or affects the entire file by typing a random number into a completely new, unformatted worksheet within the same workbook.

Solution 1Recommended

Reset Cell Alignment and Text Orientation

Manually correcting the cell's alignment settings is the quickest way to resolve vertical stacking caused by accidental orientation changes.

Often, the text orientation setting for specific cells gets accidentally changed to a vertical degree. Resetting this back to zero degrees will force the numbers to display horizontally again.

Select the affected cells

Use your mouse to highlight all the cells where the numbers are currently displaying vertically.

Open the Format Cells menu

Right-click the highlighted area and select 'Format Cells' from the context menu, or press 'Ctrl + 1' on your keyboard.

Adjust the Orientation

Navigate to the 'Alignment' tab. In the 'Orientation' section on the right, change the degrees to '0' or drag the text pointer to the horizontal position.

Apply and adjust row height

Click 'OK' to apply the changes. You may then need to double-click the bottom boundary of the row header to AutoFit the row height back to normal.

Reset Cell Alignment and Text Orientation

Immediate Resolution: If the issue was purely an alignment setting, the numbers will instantly revert to standard horizontal display.

Solution 2

Clear Corrupted Cell Formatting

Clearing all cell formats removes hidden or damaged conditional formatting rules that might be forcing numbers to display incorrectly.

Solution 3

Copy Data as Values to a New Workbook

Transferring just the raw data to a fresh file bypasses deep-rooted workbook corruption that prevents formatting changes from taking effect.

Effortless Spreadsheet Management

Fix Cell Formatting Easily with WPS Spreadsheet

If your Excel file is dealing with persistent formatting corruption, try opening and repairing it in WPS Spreadsheet. It offers an intuitive interface to seamlessly manage cell alignments, orientation, and complex data formats without hassle.

1. Download WPS Office: Install WPS Office Free from the official website and launch WPS Spreadsheet.
2. Open your problematic file: Click 'Open' and select the spreadsheet containing the vertically aligned numbers.
3. Access Format Cells: Highlight the problematic numbers, right-click, and choose 'Format Cells'.
4. Reset alignment: Under the 'Alignment' tab, easily set the text orientation to 0 degrees and click 'OK'.

Completely free to download and useHigh compatibility with all Microsoft Excel formats (.xls, .xlsx)Intuitive and easy-to-navigate cell formatting menusLightweight software that quickly opens heavily formatted files

microsoft office alternative - wps office

Frequently Asked Questions

Why do only my numbers appear vertically while text displays normally?

This usually occurs because specific custom number formats, damaged numeric styles, or specific conditional formatting rules were applied exclusively to numeric values in the workbook, leaving text cells unaffected.

Can column width settings cause numbers to stack vertically?

If a column is extremely narrow and 'Wrap Text' is enabled, numbers might wrap if they contain spaces or specific delimiters. However, true vertical character stacking (where every digit is on a new line regardless of column width) is almost always caused by the Text Orientation setting.

How do I fix the row height after fixing the number alignment?

Once you reset the text orientation to horizontal, the row might remain unnecessarily tall. To fix this, hover your cursor over the bottom border of the row number on the left side of the screen until it becomes a double arrow, then double-click to AutoFit the row height.

Document & File Issues