Quickly See All the Formulas in Excel with This Shortcut

I've been flat out so haven't updated this in a while - apologies to those who've used it as a resource. I came across this today, which has been timely as I needed some help with a pesky spreadsheet. Something wrong with some numbers in that spreadsheet? Lifehacker has a shortcut that displays all the formulas in the sheet at once. Check out Lifehacker... … [Read more...]

Making Search Relevant and Recent (Getting Help that Helps!)

Often, when people search for information on the web, they put search terms into Google and click search. This is especially relevant to searching for solutions to software problems as you want the solution to apply to the version of software that you currently have (if you have the most up-to-date version). Unfortunately, this general search method gives you a very large selection of web pages … [Read more...]

Integrating Google Maps in your documents (taking screenshots)

A friend of mine recently asked how can he integrate a Google Map into his document. The easiest way to do this is using a screen shot, however it is important to note that if you are going to use a map from Google, you need to attribute it. According to my reading of this page on Google Permissions, and this page on Attribution the easiest way to do this is to: Take a screenshot that includes … [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...]

FAQ: How to Show Column A in LibreOffice Calc

I recently had a comment in response to FAQ: How to hide columns in OpenOffice.org Calc [Show / Hide] and decided to answer it with a video. It details two methods: A method in which you can show (unhide) all columns (this can be applied to rows), and  A method for unhiding column A alone   … [Read more...]

Changing case in Pages (iWork for Mac)

For my OpenOffice fans, my apologies for not posting on OOo or LibreOffice for a while, however I have been working in Pages for Mac recently. Just a quick tip as much for my own reference as for anyone else's - for some reason I keep losing this reference. Changing the case of letters in Pages is possible by selecting Format --> Font --> Capitalization. You can then choose the … [Read more...]

Quick tip: Changing Spelling on a Single Document in Pages (for Mac)

To change the spelling for a document in Pages, select the text you wish to use (CMD-A if all text in the document). Then open the inspector, click on the 'T' for text. Then click on 'More' Then under the heading 'Language' select the dictionary you wish to use (see screen shot) … [Read more...]

Update notifications for OpenOffice.org 3.3.0 Installations [from Rob @ Apache]

I received this in my email this morning. Get your Upgrade! We have enabled the upgrade notification server for OpenOffice.org 3.3.0.  By default OOo 3.3.0 checks for updates once a week.  When an upgrade is available, a dialog pops up and notifies the user about the update, and directs them to a website where they can learn more and download Apache OpenOffice 3.4. The update … [Read more...]

LibreOffice Portable Apps v 3.5.4 released

On June 1, 2012, PortableApps.com and The Document Foundation announced the release of LibreOffice Portable 3.5.4. LibreOffice Portable is a full-featured office suite -- including a word processor, spreadsheet, presentation tool, drawing package and database -- packaged as a portable app, so you can take all your documents and office suite wherever you go. This release updates LibreOffice to … [Read more...]