Tech Tips Home
The Best Tech Tips And Daily Deals
Newsletter On The Internet!

WorldStart Tech Tip And Store Search
Email: Password: Login Remember Me

Like what you see here? Subscribe to the Tech Tips newsletter!   Email: Subscribe

Center Titles in Open Office Calc

Wednesday, September 1st, 2010 by | Filed Under: MS Office Help

I see this all the time at school – students are forever giving me tables set up in spreadsheets where the table title is either left justified over the table columns or placed haphazardly “sort-of” in the center of the table. They just love to try to center titles by using a bunch of spaces or by putting the title in a cell that’s as close as they could get.

Either way it just looks wrong to me – especially when centering information over several columns is so very simple to do!

If this is you then you’re going to love this trick.

Before we start let me issue a warning… sometimes after cells have been merged into one certain actions will cause a problem with it… so I always wait and center up my titles after I’ve put everything together.

With that said, let’s get started.

The first thing I do is to enter my text in the left-most used column just above the table. (I like the text in the cell before I merge so that I can see the changes as I make them… it’s not mandatory to start with the text it’s just my preference.)

Now select all the cells in the row where you want your text centered.


From here we’re off to the Formatting Toolbar and we’re looking for two buttons:


Click each one – order doesn’t matter you just need them both to complete a merge and center. (OpenOffice doesn’t have a single button to do this so we need to do each step separately.)


What was “off” looking is now beautifully placed over your information.


Time to format text and really make it shine!

~ April

Leave a Reply

Like these tips? Get them for FREE in your email!

WorldStart's Tech Tips Newsletter

  • Tech Tips Daily - Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

  • Tech Tips Weekly - If you don't want our Tech Tips newsletter every day, then sign up for this weekly newsletter to get the best information of the week. Sent on Fridays.

Other Newsletters

  • WorldStart's Daily Deals - Every week, we send out great deals in our Daily Deals newsletter. Many of these deals are exclusively for our Daily Deals newsletter subscribers and can't be found with our regular specials.

  • Just For Grins - Each issue includes a couple clean jokes, some funny quotes, and a hilarious reader's story. Newsletter is sent five days a week.

Enter Email Address:


Your e-mail address is safe with us!
We only use it to send you the newsletters you request. It is NEVER disclosed to a third party for any reason, ever! Plus, if you decided you don't like our newsletters (don't worry, you'll love them), unsubscribing is fast and easy.

Free Newsletter Signup

Tech Tips Daily

Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

Tech Tips Weekly

The week's best in tech and computer help. Get your issue sent to your email every Friday!

WorldStart's Daily Deals

The very best deals on the Internet! Get a new set of incredible sales every day of the week!

Just For Grins

Clean jokes, funny quotes, and hilarious comics. Sent 5 times a week straight to your email.


Love Worldstart? Refer A Friend!

WorldStart's Premium Membership

Tip Archive