Adjust the width and height of a spreadsheet column or row
Many of the below suggestions also work in other spreadsheet programs like Google Docs and OpenOffice Calc.
Adjust the width of a spreadsheet column
To adjust the width of a column in a spreadsheet program like Microsoft Excel, move the mouse in between the column header until a double arrow is shown. Once the arrow is visible, click and drag the mouse to the right or left to increase or decrease the column width.
For example, to increase the width of the "A" column, move the mouse to the line that separates the "A" and "B" column, then click and drag that line to the right. Once the column is wide enough, let go of the mouse button, as shown in the picture.
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.
You can also change the width of one or more columns by following the steps below.
- 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.
Using the steps above, you can set the width of multiple columns to be the same.
Adjust the height of a spreadsheet row
To adjust the height of a row in a spreadsheet program like Microsoft Excel, move the mouse in-between the row header (on the far left side of a row) until a double arrow is shown. Once the arrow is visible, click and drag the mouse down or up to increase or decrease the row height.
For example, to increase the height of the "1" row, move the mouse to the line that separates the "1" and "2" row, then click and drag that line down or up. Once the row is tall enough, let go of the mouse button.
Also, you can double-click the line between rows to automatically resize the row to the tallest cell in the row.
You can also change the height of one or more rows by following the steps below.
- 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.
Using the steps above, you can set the height of multiple rows to be the same.
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.
If Wrap text is not enabled, any text that is larger than the cell will overflow into empty cells. If the cell to the right of the cell is not empty, the text will appear to be cut off.
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.
Select the cell
Move to the cell you want to adjust the width or hight 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, if you wanted to adjust the width of the cell B10, you would press the right arrow to move to column B and then press the down arrow nine times to get to cell B10. Once in this cell, you would press the Alt and H key 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 the W key to adjust the cell column width. If successful, a Column Width box will open with a numerical value of the width of the cell and increasing or decreasing this value will increase or decrease the size of the column.