[Solved] Text Centered across multiple cells

Discuss the spreadsheet application
Post Reply
Padeen
Posts: 27
Joined: Fri Nov 23, 2018 9:32 pm

[Solved] Text Centered across multiple cells

Post by Padeen »

I had no prob in Excel, but I haven't found out how in OpenOffice Calc to center a text title across two or more adjacent horizontal cells. Any help would be appreciated!
Last edited by Hagar Delest on Fri Feb 03, 2023 10:50 pm, edited 1 time in total.
Reason: Tagged [Solved].
Open Office 4.1.6 on Windows 10
User avatar
Zizi64
Volunteer
Posts: 11362
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Text Centered across multiple cells

Post by Zizi64 »

Use the "Merge cells" function.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
KenJoGemCoins
Posts: 1
Joined: Fri Feb 03, 2023 9:25 pm

Re: Text Centered across multiple cells

Post by KenJoGemCoins »

Yes! TY TY TY to the member who posted a reply over three years ago to such a basic spreadsheet question for Excel gurus who could not stumble upon the hiding in plain site easy peasy function in an Open Office spreadsheet. The Excel >>> Format >>> Center Across Selection >>> Check the dialogue box is located under Format >>> Merge Cells becomes an available option here in an Open Office Spreadsheet (only after right clicking and highlighting at least two adjoining horizontal cells).
Open Office 4 On Windows 12
Post Reply