You have text or numbers in an Excel cell that are cut off or hidden. This happens when the row height is too small for the content. The quickest way to fix this is by manually dragging the row border. This article shows you the exact steps to resize rows for clear, readable data.
Key Takeaways: Adjusting Row Height Manually
- Drag the row border: Changes the height of a single row instantly to fit your content.
- Double-click the row border: Automatically sets the row height to match the tallest cell in that row.
- Select multiple rows before dragging: Applies the same new height to all selected rows at once.
How Manual Row Height Adjustment Works
Row height in Excel is measured in points, where one point equals 1/72 of an inch. The default height is 15 points. When you type more text than can fit in the default height, Excel does not automatically expand the row. The cell content appears cut off, or text spills into adjacent cells if they are empty. Manually dragging the border gives you direct control over the visual spacing of your data. This method is ideal for quick formatting adjustments without opening menus. You can adjust one row, several rows, or all rows on the sheet.
Steps to Change Row Height by Dragging
Follow these steps to resize rows using your mouse. Ensure your Excel worksheet is not in Protected View or shared, as these modes can restrict formatting.
- Move your cursor to the row header
Look at the left side of your worksheet for the numbered row headers. Position your mouse pointer on the bottom border line of the row number you want to adjust. For example, to change the height of row 5, place the pointer on the line between row headers 5 and 6. - Click and hold when the cursor changes
The mouse pointer will change from a white cross to a black double-headed arrow with a horizontal bar. This specific cursor indicates you are in the correct position to resize the row. Click and hold the left mouse button. - Drag the border up or down
While holding the mouse button, drag the border downward to increase the row height. Drag it upward to decrease the height. A small tooltip will appear showing the current height in points as you drag. - Release the mouse button to set the height
Let go of the mouse button when you are satisfied with the new height. The row will immediately resize, and any wrapped text or large font sizes within that row will now display fully.
Adjusting Multiple Rows at Once
To make several rows the same height, use this method.
- Select the target rows
Click and drag over the row numbers in the header to highlight multiple rows. You can also click one row number, hold Shift, and click another row number to select a contiguous range. - Drag any border within the selection
Move your cursor to the bottom border of any selected row header. When the double-headed arrow appears, click and drag. All selected rows will change to the new height simultaneously when you release the mouse button.
Using AutoFit by Double-Clicking
For a perfect fit, use the AutoFit feature. Place your mouse pointer on the bottom border of the row header, just as in step one. Instead of dragging, double-click the left mouse button. Excel will instantly expand or shrink the row height to the minimum size needed to display the tallest cell’s content, including any text wrapping.
Common Mistakes and Things to Avoid
Dragging the Wrong Border or Area
If the cursor does not change to the black double-headed arrow, you are not on the correct border line. Ensure you are on the thin line between row numbers in the header, not on the column header border or inside a cell. Clicking inside a cell and dragging will move the cell’s content, not change the row height.
Rows Reverting to Default Height
If rows you manually adjusted suddenly snap back to a standard height, check for merged cells or specific cell formatting like ‘Shrink to Fit’. These settings can conflict with manual height adjustments. Also, verify that the worksheet is not protected under the Review > Protect Sheet tab.
AutoFit Does Not Work on Empty Rows
Double-clicking a row border to AutoFit will have no visible effect if all cells in that row are empty. AutoFit requires content, such as text, a number, or a formula, to calculate the necessary height. For empty rows, you must drag the border manually.
Manual Adjustment vs. Format Menu: Key Differences
| Item | Dragging the Border | Home > Format > Row Height |
|---|---|---|
| Speed | Fast, visual, one-step action | Slower, requires dialog box input |
| Precision | Visual estimation, tooltip shows points | Exact numerical entry in points |
| Best For | Quick readability fixes and on-the-fly formatting | Setting identical, precise heights for multiple rows |
| AutoFit Access | Double-click the border | Menu path: Home > Format > AutoFit Row Height |
You can now quickly make your Excel data readable by dragging row borders. Use the double-click AutoFit trick for cells with wrapped text. For advanced control, try setting a precise minimum height for an entire sheet by selecting all rows with Ctrl + A before dragging one border.