How to make text centered in cell in openoffice spreadsheet?

Question

Is there anyway to make text centered in cell in openoffice spreadsheet? By center， I mean the same white space between left and right, top and bottom of the text.

Thanks in advance!

Answer 1

With the sidebar, it can be done with only two clicks, circled in red below.

If you do not see the sidebar, then it can be expanded by clicking on the dots circled in green. Make sure View -> Sidebar is checked.