Excel does not have a separate row-width setting: a row extends across the worksheet’s columns, and its horizontal space is determined by the width of each column. To make cells wider, change the column width; to make a row taller, change its row height.
What “row width” means in Excel
People often say “row width” when they mean the width of the cells across a row. In Excel, however, width belongs to a column, not to an individual row or cell. A cell’s displayed dimensions come from the intersection of its column’s width and its row’s height. For example, widening column B changes the width of B2, B3, and every other cell in column B, but it does not change the width of the cells in row 2 in other columns.
This distinction matters when formatting a table. If a heading in B2 is cut off, you can widen column B, wrap the heading, or use another display option. You cannot widen only B2 without changing the width of column B. Likewise, a row can be made taller for wrapped text, but that taller height applies across the entire row.
How Excel’s worksheet grid works
An Excel worksheet is a grid of rows and columns. A worksheet can contain 1,048,576 rows and 16,384 columns, with the last column named XFD. Every row runs horizontally across those columns, while every column runs vertically through the rows. Because row width would duplicate the widths of all the columns it crosses, Excel provides column-width controls instead.
Widths are controlled per column, or for a group of selected columns. You can give column A one width and column B another, for example, to make a narrow ID field beside a wider description field. The same column widths apply all the way down the sheet; row-specific formatting does not override them.
Column width units and maximums
Excel’s Column Width box uses a character-based unit rather than a simple measurement in inches. The number is based on the width of characters in the workbook’s standard font, with a small amount of cell padding. As a result, a width of 10 does not mean exactly 10 characters of every font, nor does it guarantee that every 10-character string will fit. Wide letters, narrow letters, font choice, and formatting all affect how much text is visible.
The maximum column width is 255 characters in Excel’s width measurement. The maximum row height is 409 points. These are separate limits: the first applies to columns, and the second applies to rows. A column set to its maximum may still not be a practical way to display very long text; wrapping, a larger row height, or a different layout may be easier to read.
On screen, the apparent size also depends on display scaling and Excel’s zoom level. Zoom changes how large the worksheet looks, but it does not change the stored column-width setting. If a column seems to occupy a different number of screen pixels on another computer, the font, display scaling, or application version may contribute to the difference.
How to change a column’s width
In Excel for Microsoft 365 on Windows, use the ribbon to enter a particular width:
- Select a cell in the column, or select the column by clicking its letter at the top of the worksheet. To set several columns together, select all of their column letters.
- Choose Home > Cells > Format > Column Width.
- Enter a value and select OK. The selected column or columns will use that width.
You can also point to the boundary between two column letters and drag it left or right. Dragging the boundary after a selected column changes that column’s width. To apply one width to several columns, select them first, then drag a boundary or use the Column Width command. On Excel for Mac, the same ribbon formatting options are available, though keyboard shortcuts and some interface details can differ.
For example, if a product code fits but its adjacent product description does not, widen the description’s column rather than the entire row. This keeps the code column compact and gives the text more room. If the sheet is intended for printing, check the page layout as well: a wider column can cause the printed sheet to span additional pages.
AutoFit, wrapping, and other ways to show text
AutoFit adjusts a column to accommodate the longest displayed entry among its cells. To use it, select one or more columns and choose Home > Cells > Format > AutoFit Column Width. Another quick method is to double-click the boundary on the right side of a column letter. AutoFit is useful for short labels or lists, but a single unusually long entry can make the whole column very wide.
Consider these alternatives before making a column extremely wide:
- Wrap Text: Select the cells and choose Home > Alignment > Wrap Text. Text appears on multiple lines within the existing column width. Excel may increase the row height to show the wrapped lines.
- Merge cells: Merging can create a wider heading area, but it changes the worksheet structure and can complicate sorting, filtering, and selecting cells. It is usually better reserved for presentation headings, not ordinary data tables.
- Shrink to fit: This reduces the displayed font size within a cell to fit the column. It can help with a short heading, but a long value may become difficult to read.
- Allow overflow into blank cells: Text can appear across neighboring empty cells. If the next cell contains a value, the text is visually cut off at the cell boundary, but the full content remains in the original cell.
AutoFit is not a guarantee that every layout will look ideal. Merged cells can prevent normal AutoFit behavior, and a column sized to today’s entries may become too wide after new data is added. For a report with a known layout, a fixed width plus wrapped text can be more consistent than repeatedly fitting to the longest value.
Row height is the separate vertical setting
If the real problem is that text is hidden vertically, adjust row height rather than column width. Select the row by clicking its number, then choose Home > Cells > Format > Row Height and enter a value. You can also drag the boundary below the row number. To size a row to its contents, select it and choose Home > Cells > Format > AutoFit Row Height, or double-click the boundary below the row number.
Row height is measured in points, where 72 points equal one inch. Wrapped text often causes Excel to increase a row’s height automatically, but a manually fixed height can leave some lines hidden. If wrapped text appears incomplete, select the affected rows and use AutoFit Row Height. Check for merged cells too, since they can interfere with automatic sizing.
When you change the height of a row, every cell in that row becomes taller. This can make a worksheet harder to scan if only one cell needs extra space. For long notes, it may be clearer to place the note in a wider dedicated column, use wrapping selectively, or keep detailed text on a separate sheet.
Common problems and practical fixes
A common misconception is that a value has been deleted when it is only hidden by a narrow column. Click the cell and inspect the formula bar to see its full contents. If the full value is there, widen the column, apply Wrap Text, or use AutoFit. For numbers, a narrow cell may show hash marks instead of the formatted value; widening the column often reveals it. Hash marks can also appear when a date or time is outside Excel’s supported display range, so check the underlying value if resizing does not help.
If AutoFit makes a column enormous, look for a long note, a stray space, or an unusually long entry farther down the column. You can select the cells you actually use and choose AutoFit, or set a deliberate width and wrap the text. If the column looks wrong only on screen, verify that you are comparing the same font and zoom level before changing the stored width.
For a table that will be printed, use Print Preview after adjusting widths. The worksheet may fit on screen but exceed the paper’s printable width. Page scaling can shrink the whole printout, but that may make text too small. Reorganizing columns, using landscape orientation, or printing selected columns can be more readable than forcing every column onto one page.
Frequently Asked Questions
Can I change the width of just one Excel row?
No. Excel assigns width to columns, and a row spans all the columns in the worksheet. You can change one or more column widths, or make a row taller, but you cannot give a single row its own horizontal width.
What is the maximum column width in Excel?
The maximum column width is 255 in Excel’s character-based width units. The exact displayed space depends on the workbook’s standard font and formatting, so the number is not a universal pixel or character count for every kind of text.
How do I make all columns the same width?
Select the columns you want to change by dragging across their column letters, or select the whole worksheet using the square at the top-left corner of the grid. Then choose Home > Cells > Format > Column Width, enter a value, and select OK. Applying a width to the entire sheet can make some data unnecessarily cramped or spacious.
Why does AutoFit make a column too wide?
AutoFit considers the displayed contents in the selected column. One long entry, including a note or an unexpected value far down the sheet, can determine the width. Find the entry responsible, then set a fixed width and use Wrap Text if that better suits the layout.
Why is wrapped text still cut off?
The row may have a fixed height that is too small, or merged cells may be interfering with automatic sizing. Try Home > Cells > Format > AutoFit Row Height. If that does not resolve it, increase the row height manually or review the merged-cell layout.
Related
- PowerPoint Table Diagonal Split Cell: Practical Methods
- Data Validation and Quality Assurance in Excel
- Power Query Remove Leading Zeros Without Losing IDs
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Delete a Blank Page in Word: A Simple Step-by-Step GuideTo delete a blank page in Word, show formatting marks with Ctrl+Shift+8 on Windows or Command+8 on Mac,…
- How to Make a Flowchart in Microsoft Word, Step by StepTo make a flowchart in Microsoft Word, open a document, choose Insert > Shapes, add flowchart shapes for…
- Excel Cell Size: Adjust Row Height and Column WidthTo format cell size in Excel for Microsoft 365 on Windows, adjust the row height, the column width,…
- Excel Data Validation Drop-Down Lists: Setup and FixesTo create a drop-down list in Excel for Microsoft 365 on Windows, select the cells, choose Data >…
- Percentage Calculation in Google Sheets: Formulas & TipsTo calculate a percentage in Google Sheets, divide the part by the total, then format the result as…
- Excel Test Cell Content: How to Check Values and TypesTo test what a cell contains in Excel, use a formula suited to the question: =ISBLANK(A2) checks whether…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.