How to make cells in Excel one line?

Question

openoffice

Now the cells are displayed according to the size of the test in them:

but I need it like this:

Something Google does not help, maybe I'm not looking for it.
Preferably in Calc, but also in Excel.
Already tried everything.

Answer 1

You select the entire table
RMB on the line between the rows

spoiler

Row height

spoiler

Put for example 14, click OK

spoiler

you get the same row height across the whole table

spoiler