Providing tips, tutorials and templates for various Office applications
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...]
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...]
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...]
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...]
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...]
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...]
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...]
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 allowing me to view the data inside, which is certainly better than … [Read more...]
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...]
Amazon affiliate: Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting Let's say you have a number of rows of data, and you need to be able to scroll or search up and down them, but whenever you do, you lose sight of the headings. These instructions work for Calc in both OpenOffice.org AND NeoOffice. In order to freeze the header rows so that they don't … [Read more...]
Recent Comments