Resetting the Mac OS X dock to the default settings the fruit company originally offered is a common task users would love to know how to do. Most people will play with their docks and customize them. However, it’s not usual...
Apple make an outstanding operating system in OS X. Apple also creates some unique names for it’s apps and services from within that OS. If you are a frequent user of Windows and not Mac, you might not know about the Launchp...
Most office suites probably don’t include options to create barcodes with. OpenOffice doesn’t have any built-in barcode options, but you can add the Barcode plug-in to it. Then you can quickly set up a barcode with the...
It might be handy to have a calculator at hand when setting up documents with OpenOffice applications that aren’t spreadsheets. Sure, you can always open Calculator in Windows, but that doesn’t include a matrix operato...
Bookmarks are something you can add to OpenOffice documents. You can add bookmarks as a shortcut that when selected jump to a specific point in the document. In addition, you can also add visible bookmark points to documents with ...
Sudoku is a game in which you fill out a grid so that the rows, columns and sub grids include all the digits from one – nine. Now you can add this game to OpenOffice Calc spreadsheets. The Sudoku OpenOffice plug-in adds formatted ...
Draw is one of the OpenOffice applications that you can add plug-ins to. The Diagram extension is a good addition to Draw. With that you can quickly set up organization diagrams. This is the Diagram page on the OpenOffice website....
Another post covered OpenOffice’s VLOOKUP function to look up data with. Calc also has a HLOOKUP function that is similar. However, with HLOOKUP you can look up data in tables that have horizontal layouts. For example, set u...
This post covered how to add more templates to OpenOffice. In addition, you can also set up custom templates with your own layout and design. Custom templates will include headers, footers and placeholders that you can add to docu...
Templates give you a great shortcut for setting up documents such as letters. OpenOffice includes a variety of templates for spreadsheets, presentations and text documents; but it opens a default blank template when you press the ...
If you have a OpenOffice Calc spreadsheet with lots of blank cells in columns, there are a few ways to remove them. You could select the cell’s rows, right-click and then click Delete Rows. However, this is a better way to d...
OpenOffice Calc is an application that includes a variety of spreadsheet functions. VLOOKUP is one of its functions you can add to spreadsheets. With that you can look up data from within a table. Let’s suppose you have a s...
Sometimes Calc users might need to split data in one column into another. As such, Calc has a Text to Columns option for splitting columns. With that you can cut your spreadsheet columns down to size. Open a spreadsheet and then ...
Impress is the presentation application included with the OpenOffice suite. With it you can set up presentations, as covered here, and photography slideshows. You can set up a photo album slideshow more quickly by adding the Photo...
Calc is OpenOffice’s spreadsheet application with which you can set up tables that include fields and records. So you can set up flat-file (single table) databases with the package. However, the software doesn’t includ...
