Autofit a Column Using Selected Cells in OpenOffice Calc

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 piece of data but, instead … Continue reading Autofit a Column Using Selected Cells in OpenOffice Calc

OpenOffice.org Calc: Avoiding the Delete Contents Dialog Box

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 box appears. Okay, so maybe you like this … Continue reading OpenOffice.org Calc: Avoiding the Delete Contents Dialog Box

OpenOffice.org Writer: Every Other Page Headers and Footers

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 … Continue reading OpenOffice.org Writer: Every Other Page Headers and Footers

OpenOffice.org: Gallery Display Relocation

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 … Continue reading OpenOffice.org: Gallery Display Relocation

Keystroke Shortcuts for Divider Lines in OpenOffice Writer

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 … Continue reading Keystroke Shortcuts for Divider Lines in OpenOffice Writer

Inserting Text Above or Below a Table in OpenOffice Writer

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. You need … Continue reading Inserting Text Above or Below a Table in OpenOffice Writer