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.

Matching Colours in Microsoft Office [Powerpoint, Word & Excel]

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.

Google Drive – Online Storage and Backup [Alternate Download Locations]

online-storage

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

Freezing or Unfreezing Rows in Google Docs Spreadsheets

freeze-rows-google-docs

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

Setting Delimiters when opening a CSV File (OpenOffice Calc)

delimeters

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

Question: Why does the header row keep moving when I sort?

sort-range

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