Home life · Updated
How to Shrink Rows in Excel: Quick Steps
Quick answer To shrink rows in Excel, select the rows, then drag the bottom border of any selected row up, or use the Row Height option to set a smaller height.
Shrinking rows in Excel means reducing their height so the spreadsheet takes up less space and looks neater. This is useful when you have rows that are too tall, or when you want to make more rows visible on the screen. You can shrink rows manually, set an exact height, or let Excel auto-fit based on the content. No special skills are needed—just a mouse and a basic understanding of Excel’s interface.
What You’ll Need
- A computer with Microsoft Excel installed (or a free online version like Excel for the web).
- A spreadsheet with rows you want to shrink.
- A mouse or trackpad to click and drag.
Step-by-Step
- Open your spreadsheet – Launch Excel and open the file containing the rows you want to shrink. If you’re using Excel for the web, go to the file in your browser.
- Select the row(s) – Click on the number of the first row you want to shrink (the gray box on the left side). To select multiple rows, click and drag over the row numbers, or hold Ctrl (Windows) or Cmd (Mac) while clicking each row number. To select all rows, click the triangle at the top-left corner where the row numbers and column letters meet.
- Drag to shrink manually – Move your mouse cursor to the bottom edge of any selected row number (the line between two row numbers). The cursor will change to a double-headed arrow (up and down). Click and drag upward to decrease the row height. As you drag, a tooltip shows the current height. Release the mouse button when the row is at the desired height.
- Use the Row Height option for exact control – If you need a specific height, right-click on any selected row number and choose Row Height from the context menu. In the dialog box, type a number (in points) for the height. Lower numbers make rows shorter. Click OK to apply.
- Auto-fit to content (optional) – If you want Excel to automatically shrink rows to fit the content, select the rows, then go to the Home tab, find the Cells group, click Format, and choose AutoFit Row Height. This will set each row to the minimum height needed to display its content. Note: this may not shrink rows if the content is tall; it only adjusts to fit content, so it might increase height if needed.
- Confirm the changes – Click anywhere outside the selected rows to see the result. If the rows are still too tall, repeat the drag or Row Height method with a smaller number.
Common Mistakes
- Dragging the wrong edge – Some users drag the top edge of a row, which actually resizes the row above. Always use the bottom edge of the row number you want to change.
- Selecting only cells, not rows – If you select cells (e.g., A1:A10) and drag the bottom border of the selection, you might not affect the row height as expected. You must select the entire rows by clicking the row numbers.
- Using AutoFit when you want a fixed height – AutoFit adjusts to content, so if your content is tall, it will make rows taller, not shorter. For shrinking, use manual drag or set a specific height.
- Forgetting to select all rows – If you only select one row and drag, only that row shrinks. To shrink multiple rows at once, select them all first.
Tips
- Use the ribbon for precision – The Format button under the Home tab also has Row Height and AutoFit Row Height. This is handy if you prefer menus over right-clicking.
- Shrink to fit more rows on screen – If you want to see more rows without scrolling, set a smaller row height (e.g., 12 points) for all rows. This can make a big difference in large spreadsheets.
- Combine with column width – For a compact view, also adjust column widths. This helps when you want to print or view more data at once.
- Undo if it goes wrong – Press Ctrl+Z (Windows) or Cmd+Z (Mac) to revert any accidental changes.
- Check for hidden rows – If a row seems stuck, it might be hidden. Select the rows around it and use Format > Hide & Unhide > Unhide Rows to bring it back.
Troubleshooting
Rows won’t shrink below a certain height – Excel has a minimum row height of about 0.08 inches (6 pixels). If you try to go smaller, it will snap to that minimum. This is normal.
Dragging doesn’t work – If the double-headed arrow doesn’t appear, make sure you’re on the border between row numbers, not on the row number itself. Also, ensure your mouse pointer is exactly on the line. If you’re using a touchpad, try tapping and dragging with two fingers.
Rows revert to original height after saving – This can happen if the row height is set to “Auto” (the default). To keep a fixed height, right-click the row, choose Row Height, and type a number. This overrides the auto behavior.
AutoFit makes rows taller, not shorter – AutoFit only adjusts to fit content, so if your text wraps or has large fonts, it will increase height. To shrink, use manual drag or set a specific height, and consider reducing font size or removing wrapped text.
Multiple rows don’t shrink together – When you drag the bottom edge of a selected group, all selected rows change to the same height. If they don’t, ensure you selected the entire rows (gray numbers), not just cells.
Frequently Asked Questions
How do I shrink all rows in a worksheet at once?
Select all rows by clicking the triangle at the top-left corner (where row numbers and column letters meet), then drag the bottom edge of any row number up, or use Format > Row Height and enter a smaller number.
Can I shrink rows to a specific pixel height?
Yes, but Excel uses points, not pixels. One point is about 1/72 inch. You can type a decimal number in the Row Height dialog, such as 10.5. The minimum is 0.08 inches (around 6 pixels).
Why does my row height keep changing automatically?
This happens when the row is set to “Auto” height. Excel adjusts it when you change content. To prevent this, set a fixed height via Row Height and avoid using AutoFit.
How do I shrink rows without affecting the content?
Shrinking rows only changes the height; it doesn’t delete or alter content. However, if the content is taller than the row, it may be cut off visually. To avoid this, ensure the row is tall enough to show all text, or reduce font size.
Is there a keyboard shortcut to shrink rows?
No direct shortcut, but you can use Alt+H, O, H (Windows) to open the Row Height dialog after selecting rows. On Mac, use the menu bar.
Can I shrink rows in Excel for the web?
Yes, the same drag and Row Height options are available in Excel for the web, though the menus may look slightly different. Right-click a row number and choose Row Height.
Related
- How to Fix a Leaking Bathroom Shower
- How to Activate Windows 11 Pro (Step-by-Step)
- How to Phone Portugal from UK: Dialing Guide
Sources: Microsoft Support. Menus and buttons can differ slightly by version. Spotted something out of date? Tell us.