New Line in Excel [Mac, Windows]

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. … [Read more...]

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

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 lately in the online storage … [Read more...]

Freezing or Unfreezing Rows in Google Docs Spreadsheets

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 Go to the View menu. Then, point your mouse to Freeze … [Read more...]

Setting Delimiters when opening a CSV File (OpenOffice Calc)

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, then close the file and go to File >> Open. Then select the CSV file and the following window … [Read more...]

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

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 on the Options tab and ensure that the "Range contains column labels" tick box is checked (or … [Read more...]

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

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 CMD-F (Mac). Alternatively, you can go to the ‘Edit’ Menu, and select ‘Find … [Read more...]

5 Tips for Office Productivity [from my Weekend Reading]

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! … [Read more...]

6 Sigma Presentation Layout [LibreOffice, OpenOffice.org, NeoOffice]

I've put together this 6 sigma presentation layout for free download and use in Impress. ** UPDATE - now with a Microsoft Powerpoint version. … [Read more...]

6 Tips for Microsoft Word [from my Weekend Reading]

Over the weekend I was doing some reading, and I noticed that I had flagged the following tips for use in Microsoft Word. I hope they're of use to you! Use F3 To Change An Entire Sentence To Uppercase, Lowercase, or BLOCK LETTERS What’s the quickest way to change an entire sentence to Uppercase, lowercase, or BLOCK LETTERS? 10 Ways to recover a corrupted Word document It sucks when docs … [Read more...]

From a Reader: How to Install Templates?

Hello Stephanie, I am using LibreOffice 3 which came with Ubuntu 11.04. I am also new to OpenSource. I would like to use new templates that I have found on OpenOffice.org and on your site, but can not figure out where to load the Templates or how to get them into the Template section. I know this might be a simple task, but I am totally lost as to how to get this done. Regards, J A K … [Read more...]