Category Archives: Windows

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 ...

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...

When you open multiple windows the most recently opened takes precedence over the others. As such, the most recently opened window overlaps all the others. You can keep any window on top by pinning them with the PinMe software.
To...

Since the very early builds of Windows 10 Technical Preview, Microsoft pushed out the totally redesigned Store. As a beta product, Windows 10 has gradually added more and more features into this new Store. In this post, we’...

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...

Do you need to convert lots of numbers in a spreadsheet to text? If so, you can do exactly that with OpenOffice’s Numbertext plug-in. That’s a plug-in which adds a new NUMBERTEXT function to Calc spreadsheets.
Open thi...

In recent builds of Windows 10 Technical Preview, Microsoft added a new set of Mail and Calendar apps that will replace Mail, People and Calendar apps in Windows 8.1. The new Mail app now is stamped with Outlook brand in order to ...

Drivers are software that operates desktop or laptop hardware devices. So without the required drivers a hardware device such as webcam won’t work correctly. You can open a list of your drivers with the Command Prompt in Win...

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...

OpenOffice applications have a variety of options. Its Drawing toolbar includes options that you can add shapes to documents with. In addition, you can also add 3D effects to those shapes.
Open a OpenOffice application such as Wri...

To add page numbers to OpenOffice documents, you would usually add a header or footer to the document first and then select Insert > Fields > Page Number. However, with the Pagination plug-in you can add page numbers directl...