Many times when we’re working with data in a spreadsheet we need to know the sum of a range of data. Here’s a couple of suggestions for finding the sum of cells quickly. Continue reading
Often we need to Spellcheck a document in a foreign language and, unfortunately, we don’t have one. Until now, that is… Continue reading
Do you know the difference between relative and absolute references? April expands on this, plus the power of the $ symbol in this handy Open Office Calc tip! Continue reading
Looking for a way to easily insert title rows into Open Office Calc before printing? No luck so far? Let April be your guide in this handy tip! Continue reading
If you’re like me – a Microsoft Office user for years and years – then you’re very used to the concept of the Page Setup. Things such as margins and page orientation could be located there. Open Office has this option, too – just in a different place… Continue reading
Today I’d like to share an interesting thing that I stumbled across with playing with the drawing tools in OpenOffice.org – specifically, I’d like to show you what I found when I was exploring the options for a text box… Continue reading
Here’s a quick tip for selecting text using your mouse that doesn’t require dragging the mouse, holding down the mouse button or using the Shift key. Continue reading
Here’s a neat tip on how to access the built-in thesaurus in Open Office Writer! Spice up your writing with the right words! Continue reading
Looking for some free label templates to use with Open Office Writer? April may have just the site you’re looking for! Give it a look! Continue reading
Have you ever needed to split a numbered list in a document and everything BUT that happened? April has the solution, and you can check it out here! Continue reading
Got a picture in the background for an Open Office Writer document and now you can’t select it? April had the same problem, but thankfully, she found a solution! Continue reading
Want to learn a quick and easy way to insert frequently used special characters like Trademark, Copyright and more into Open Office Writer with a few keystrokes? Check it out! Continue reading
Recently while working in OpenOffice.org Writer, I found myself repeating my actions over and over again.
I knew that MS Office had a way to repeat the last action or word entered, so I went looking for what Writer has to offer.
What I found was on the Edit menu:
The Autofit feature in Calc and other spreadsheet programs is an extremely helpful feature.
You can simply double-click on the right divider line in the column title, and the column will automatically expand to fit the longest piece of data.
But what if you don’t want to fit the longest
If you’ve used OpenOffice.org Calc at all, I know that you’ve found the Delete Contents dialog box.
How could you not?
Every time you select a cell or range of cells and try to clear their contents you automatically hit the Delete button and that annoying dialog
Have you ever needed your headers or footers to be different on odd and even pages?
Maybe you’ve created a document that will eventually be put together like a book so the pages that will end up on the right of the finished document need the page number on the right side of the page with the same scenario for the left side pages.
If you use a lot of graphics in your OpenOffice.org documents, you’re probably in a love/hate relationship with the built-in graphics Gallery.
Love to access the graphics, hate the space that the gallery eats up on your screen….
Well, to be truthful, the problem with the space it takes, is that my monitor is wide-screen and
OpenOffice.org Writer: Quick Divider Lines Using 4 Simple Keystrokes
Every once in a while, you just need a horizontal line in your document to create a visual break of one thing to another… maybe you need to separate a page “headline” from the body of the document or separate different topics from one another in
OpenOffice.org Writer: Inserting Text Before or After a Table
It happens to anyone who uses tables in a word processing program like OpenOffice.org Writer – we insert a table at the very top of the document and find ourselves unable to add text above it because we didn’t leave a blank line there.