Hide Zero Values in LibreOffice Calc and Excel

excel-accounting

Sometimes you don’t want the zero values to show in your spreadsheet. Different Office programs can handle this in different ways. Below are some examples. Do you have any way that you remove zeros from your spreadsheets? If so, please feel free to contribute in the comments section below. OpenOffice / LibreOffice OpenOffice / LibreOffice […]

[Continue reading…]

New Line in Excel [Mac, Windows]

new-line-text-excel

Quick tip: Usually when you hit the Enter key in Excel (Microsoft), it goes to the next cell. In Windows, you can hit Alt + Enter to get a new line without going to the next cell. In a Mac, you need to press Ctrl + Alt + Enter.

[Continue reading…]

Matching Colours in Microsoft Office [Powerpoint, Word & Excel]

matching-colours-3

I got a call from DH yesterday saying that all his greens didn’t match in his presentation, and could I help him out? “Easy, peasy,” said I. Here’s how you do it! In this case I was working in Powerpoint, and needed to get to where you can format the background colour of the items […]

[Continue reading…]

Google Drive – Online Storage and Backup [Alternate Download Locations]

online-storage

When creating documents (whether is MS Office, LibreOffice, iWorks, OpenOffice or whatever your favourite flavour of Office software) it’s always a good idea to have an off-site backup. Cloud storage is one way to tackle this, with the added option of synchronising files between different computers and devices. The competition has really been heating up […]

[Continue reading…]

Freezing or Unfreezing Rows in Google Docs Spreadsheets

freeze-rows-google-docs

You can freeze up to ten rows or five columns in any particular sheet in Google Spreadsheets. Freezing Columns and Rows Go to the View menu. Then, point your mouse to Freeze rows… or Freeze columns…. Select one of the options. When you scroll, you’ll notice the frozen row(s) or column(s). Unfreezing Columns and Rows […]

[Continue reading…]

Setting Delimiters when opening a CSV File (OpenOffice Calc)

delimeters

I had a question recently concerning the opening of CSV files in OpenOffice. Sometimes when we open CSV files, they open in Calc by default, and the Text Import window doesn’t appear. If this is the case for you, and the data is not being sorted into columns in a format you are happy with, […]

[Continue reading…]

Question: Why does the header row keep moving when I sort?

sort-range

In a previous post I have answered a question about sorting lists in OpenOffice.org Calc. This usually has no problems, but every now and then an occasion occurs where Calc doesn’t recognise that the first row is a header row. To deal with this, in Step 3 of the previous tutorial you need to click […]

[Continue reading…]

Read ODS, ODT & ODP Files on your iPhone or iPad

20111212-174606.jpg

I always struggle with opening OpenOffice.org open format documents on my iPhone – Apple doesn’t have this as a standard format that other applications can use. I don’t know of any applications that can edit Open Document Format files, however recently I downloaded the IBM Lotus Symphony Viewer. This works a treat in at least […]

[Continue reading…]

Replace any text with Carriage Return/Paragraph Marks in 5 Easy Steps

replace-with-cr

When you need to replace text with paragraph marks (end of paragraph) / carriage returns, OpenOffice.org, LibreOffice and NeoOffice Writer all are able using the following 5 steps (click on the image to view a larger version): Note: If you don’t know how to get to the find / replace button above, hit Ctrl-F (Windows) or […]

[Continue reading…]

5 Tips for Office Productivity [from my Weekend Reading]

1110330_57736617_sml

Once again I caught up on my reading of blogs and linked tweets over the weekend (geez, I love Flipboard!) and I’ve noted these ones for tackling any office software (Microsoft, Apple or Open Source) related projects. From installing fonts, creating pivot tables and syncing documents with Google Docs… check it out!

[Continue reading…]