In a Microsoft Excel spreadsheet, you can adjust the column width or the row height by following the steps provided on this page.

Adjust the width of a spreadsheet column

To adjust the width of a spreadsheet column, move the mouse cursor between the column headers until the cursor changes to a horizontal double-sided arrow. Once the arrow is visible, click-and-drag the mouse to the right or left to increase or decrease the column width.

Many of the suggestions below also work in other spreadsheet programs, like Google Docs and OpenOffice Calc.

  • Adjust the width of a spreadsheet column.
  • Adjust the height of a spreadsheet row.
  • How do I resize a single cell in a spreadsheet?
  • How can I adjust a cell size using a keyboard shortcut?

For example, to increase column A’s width, move the mouse pointer over the line separating the “A” and “B” column, then click-and-drag it to the right. Once the column is wide enough, let go of the mouse button, as shown in the picture.

You can also change the width of one or more columns by following the steps below.

Also, you can double-click the line between columns to automatically resize the column to the longest cell in the column, as shown in the picture.

  • Highlight one or more columns in the spreadsheet.
  • Right-click with your mouse on a highlighted column and select Column Width in the pop-up menu.
  • In the Column Width window, enter the desired width and click OK.

Adjust the height of a spreadsheet row

To adjust the height of a spreadsheet row, move the mouse cursor between the row headers until the cursor changes to a vertical double-sided arrow. Once the arrow is visible, click-and-drag the mouse down or up to increase or decrease the row height.

Using the steps above, you can set the width of multiple columns to be the same.

For example, to increase the height of row “1,” move the mouse pointer to the line separating row “1” and “2,” then click-and-drag it down or up. Once the row is tall enough, let go of the mouse button.

You can also change the height of one or more rows by following the steps below.

Also, you can double-click the line between rows to automatically resize the row to the tallest cell in the row.

  • Highlight one or more rows in the spreadsheet.
  • Right-click with your mouse on a highlighted row and select Row Height in the pop-up menu.
  • In the Row Height window, enter the desired height and click OK.

How do I resize a single cell in a spreadsheet?

It is important to realize that you cannot increase the width of only one cell in a spreadsheet. If you have only one cell with a lot of text, you can wrap text that text by right-clicking the cell, clicking Format Cell, click the Alignment tab, and checking the box for Wrap text.

Using the steps above, you can set the height of multiple rows to be the same.

How can I adjust a cell size using a keyboard shortcut?

Unfortunately, there are no single key Excel or other spreadsheet keyboard shortcuts for adjusting the width or height of a cell. However, you can do the following steps to adjust the cell size using only your keyboard and not the mouse.

If Wrap text is not enabled, any text that is larger than the cell overflows into empty cells. If the cell to the right is not empty, the text appears to be cut off.

Select the cell

Move to the cell you want to adjust the width or height of using your keyboard arrow keys.

Access Home tab format option

Once the cell is selected, access the Home tab by pressing the keyboard shortcut Alt+H. Once this keyboard shortcut is pressed all options in the Home tab will be highlighted. Press O (the letter o) to access the format options.

As seen in the picture, the Format section gives you the option to adjust the Row Height (H), AutoFit Row Height (A), Column Width (W), AutoFit Column Width (I), and Default Width (D).

For example, to adjust the width of B10, press the right arrow to move to column B and then the down arrow nine times to get to cell B10. Once in this cell, you would press Alt and H at the same time to get the Home tab keyboard options. Next, you would press O (the letter o) to get the Format options.

Finally, you would press W to adjust the cell column width. If successful, a Column Width box displays the numerical value of the cell width, and increasing or decreasing this value increases or decreases the size of the column.

  • How to print grid lines in Microsoft Excel and Google Sheets.
  • See our column and row definitions for further information about these terms.
  • Microsoft Excel help and support.