On the ribbon tab Layout | group Cells you can change the column widths and row heights of your worksheet via commands.
The command group Cells contains the following entries:
Cell size (width and height)
With the lower field you can define the width of the column. To do this, enter the desired value in the input field. Alternatively you can use the small arrow keys to increase or decrease the value.
With the field above you can set the height of the row accordingly.
Optimum width (or optimum height)
The Optimum width button sets the width of a column automatically, corresponding to the space required by the cell contents.
The command can be used in different ways:
▪When you select an entire column and choose this command, the width of the column will be adjusted to the cell that needs the most space.
Tip: The same can be achieved much faster: by simply double-clicking on the column header.
▪When you select some cells within a row and choose this command, only these cells will be used for the calculation of the optimum column width.
▪When you select some cells within a column and then choose this command, only these cells will be used for the calculation of the optimum column width.
▪If a single cell is selected and you choose this command, the column width will be adjusted to the contents of that current cell.
The height of rows can be changed the same way, using the Optimum height button.