
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.
Providing tips, tutorials and templates for various Office applications

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.
I got a call from DH yesterday saying that all his greens didn’t match in his presentation, and could I help him out?
“Easy, peasy,” said I.
Here’s how you do it!
In this case I was working in Powerpoint, and needed to get to where you can format the background colour of the items that needed changing. Usually to do this I right-click or Control-click (Mac) on the item (in the example below it was a shape, but it could be a table or text) and select ‘Format Shape…’ (or Format Text / Paragraph / Table).
Look for the “Fill” options on the left hand side of the pop-up box. This refers to Fill Colour. (See (1) in the screenshot below.)
From here you click on the ‘Solid’ pane at the top (2), then click on Color –> More Colors… (3), as illustrated in the screenshot below.
Now you should have the option to select colours.
Click on the left most colour selector icon (indicated in the screenshot below, the one that looks like a multi-coloured ball). Then click on the colour selector crosshair – it looks like a magnifying glass.
You can then position the crosshair over any colour in your presentation. To select a colour, just click anywhere on your presentation that has the colour that you want to copy.
The colour will then be selected in the colour block, and you can click OK, then OK again and your colour should be updated to match.

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 [...]
[Continue reading…]
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 [...]
[Continue reading…]
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, [...]
[Continue reading…]
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 [...]
[Continue reading…]My name is Stephanie Krishnan and I'm passionate about the way that open source software and its community can help small businesses and individuals with their productivity and lives. One of the biggest arguments I get from business owners, however, is lack of support options. I decided to put together my own support blog to help people be productive at various levels with various Office software, including OpenOffice.org, LibreOffice, NeoOffice, MS Office and Apple products! [Read More …]
Copyright © 2012 · Focus Theme on Genesis Framework · WordPress · Log in
Recent Comments