Change column widths and row heights in Excel and Google Sheets

There are several ways to extend columns in Excel and Google spreadsheets:

  • Change individual column widths or row heights with the mouse

  • Change column width or row height with ribbon options (Excel only)

Content
  1. Change column width and row height with mouse
  2. Change the width of individual columns with the mouse
  3. Automatically adjust column width with mouse
  4. Change the width of all columns in a worksheet with the mouse
  5. Change line height with mouse
  6. Change column width with ribbon options in Excel
  7. Change column width with ribbon options
  8. Change the width of all columns in a worksheet using the menu
  9. Change line height with ribbon options

Change column width and row height with mouse

Change the width of individual columns with the mouse

The steps below show how to change the width of individual columns using the mouse. Expand column A, for example:

  1. Place the mouse pointer on the boundary line between column A and B in the column header.

  2. The pointer changes to a two-headed black arrow, as shown in the image above.

  3. Press and hold left mouse button and drag the double arrow to the right to expand column A or to the left to narrow the column

  4. Release the mouse button when the desired width is reached

Automatically adjust column width with mouse

Another way to shrink or widen columns with the mouse is to let Excel or Google Sheets automatically adjust the column width to the longest data item in the column.

For long data, the column will grow, but if the column contains only short data elements, the column will shrink to fit those elements.

Example: change the width of column B with autofit

  1. Place the mouse pointer on the boundary line between columns B and C in the column header. The pointer changes to a double-headed arrow.

  2. Double click with the left mouse button. The column automatically resizes to fit the longest entry in that column

Change the width of all columns in a worksheet with the mouse

Adjust all column widths

  1. Click Select everywhere row header to highlight all columns in the current worksheet.

  2. Place the mouse pointer on the boundary line between column A and B in the column header.

  3. The pointer changes to a double-headed arrow.

  4. Click left mouse button and drag the double arrow right to expand all columns on the worksheet, or left to shrink all columns.

Change line height with mouse

The options and steps for changing the row height in Excel and Google Sheets with the mouse are the same as for changing the column width, except that the mouse pointer is placed on the boundary between two rows in the row header instead of the column header.

It is not possible to change the width or height of an individual cell. The width must be changed for the entire column, or the height for the entire row.

Change column width with ribbon options in Excel

Change column width with ribbon options

  1. Click a cell in the column you want to change – to expand multiple columns, highlight the cell in each column.

  2. Click on the tab House on the tape.

  3. Click the icon Format to open the drop-down menu of options.

  4. To automatically fit the column(s), select this option in the Cell Size section of the menu.

  5. To enter a specific size in font width, select the option from the menu Column width to open the Column Width dialog box.

  6. Enter the desired width in characters in the dialog box (default width: 8.11 characters)

  7. Click Okay to change the column width and close the dialog box.

Change the width of all columns in a worksheet using the menu

  1. Click Choose them all at the top of the row header to highlight all columns in the current sheet.

  2. Repeat steps 5 to 7 above to enter a specific size for all columns

Change line height with ribbon options

The options and steps for changing the row height in Excel using the options on the ribbon are the same as for changing the column width.

Leave a Reply

Your email address will not be published.