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