Table Properties – Did they disappear? [Irritating MS Word]

I'm not sure if it's just me, however I found this very irritating and was using the Table >> Table Properties... menu for a few days before I rediscovered the button in the ribbon. In case you missed it, in one of the updates the "Table Properties" button has been relabelled "Properties". :-) Probably obvious to a lot of people - I just had a brain-fart moment.   … [Read more...]

Alternate upgrade software location for Office 2016 for Mac

Recently I was hit with a repeated bar across the top of Microsoft Word saying that one of the advantages of having an Office 365 subscription is that I can get free upgrades to my software. Awesome, fantastic, just click here. So I did... I'm a Mac user, so these instructions are relevant to other Mac users. Sorry Windows guys - I'll post an update if DH ever asks me to upgrade his … [Read more...]

How to Extract Media from PowerPoint Files (works for both Windows and Mac)

Lately I've been receiving a number of files in pptx format, but I present using my iPad and so convert these presentations to Keynote. If the slides contain images and text only, this conversion is relatively painless - usually there are just a few formatting and alignment issues that need to be addressed and then I'm good to go. All I need do is open the pptx file in keynote, either on my Mac or … [Read more...]

FAQ: How to I change the default language in Word for Mac? [Word 2011]

With Office 2011 for Mac, you can check spelling and grammar in languages other than English. Word 2011 for Mac comes with foreign-language dictionaries such as Czech, French, Russian, and you can also change the 'brand' of English (UK, US, Australian). The default dictionary determines which language’s proofing tools Word uses for spelling and grammar. You can change Word’s default … [Read more...]

Hide Zero Values in LibreOffice Calc and Excel

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 has the option to hide the zero values … [Read more...]

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

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

OpenOffice.org, LibreOffice & NeoOffice on Mac Lion OSX – Part 2

Note: For those that don't have a Mac, we'll be back to regular programming shortly. :) On Thursday I did a quick take on what my experience was on OpenOffice.org, LibreOffice and NeoOffice after installing Mac OSX Lion. There is a website that can assist you in identifying programs that work with Lion OSX - including our favourites! … [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...]

Turning off Capitalisation in Impress and Writer [OpenOffice.org, LibreOffice and NeoOffice]

I was recently reading through a tutorial and noticed that the writer (Akkana) was frustrated with the auto-capitalisation at the beginning of sentences in OpenOffice.org Impress. Turning this feature off is relatively simple, however you need to do it in each of the programs to ensure it is applied to both Writer and Impress. I've also included links for those wanting to do this in … [Read more...]