Table Properties – Did they disappear? [Irritating MS Word]

I’m not sure if it’s just me, however I found this very irritating and was using the Table >> Table Properties… menu for a few days before I rediscovered the button in the ribbon.

In case you missed it, in one of the updates the “Table Properties” button has been relabelled “Properties”. :-)

irritating-table-properties

Probably obvious to a lot of people – I just had a brain-fart moment.

 

Can’t make Powerpoint Text Transparent

Recently I was dealing with Powerpoint and reopened an old presentation to find that the text in the presentation which had once been transparent was now no longer so.

Turns out there is a trick to this (isn’t there always :-)), which requires you to add a solid line border to the text and change the transparency of this as well. Seems it is something new in one of the recent updates – consensus seems to be this was update 15.20.

I right-clicked on the textbook and selected Format Shape… This bought up the format shape options in the right hand panel. Then ensure there is a solid fill selected for both the text fill and the text outline. See the screenshot below for exact settings.

transparency of text in powerpoint

Linking Google Sheet Cells Between Sheets (aka Spreadsheets)

This was something I’ve only done occasionally in Excel since I’ve started this blog, and never had the need to in Google Sheets – Excel has the capability to link cells from one workbook to cells in another workbook. This is also referred to as an external reference. This usually is done in the format: =[Budget.xlsx]Annual!C10 Where […]

[Continue reading…]

Alternate upgrade software location for Office 2016 for Mac

office-school

Recently I was hit with a repeated bar across the top of Microsoft Word saying that one of the advantages of having an Office 365 subscription is that I can get free upgrades to my software. Awesome, fantastic, just click here. So I did… I’m a Mac user, so these instructions are relevant to other Mac […]

[Continue reading…]

Integrating Google Forms in a WordPress Site [Following up requests]

columns-forms

I’ve had two requests in the last week for the following: “How can we have a form that people can use to request a copy of a download, and then we can follow up later? I just want to use a spreadsheet.” There are a number of autoresponder-type systems that allow you to create a […]

[Continue reading…]

How to Add a Tick Symbol ✓ to Writer documents [LibreOffice, OpenOffice]

insert-special-character

To insert the tick (✓) symbol into a Writer document, follow these instructions. From the menu (in Windows and Mac) click on Insert –> Special Character. From the Font dropdown, you need to select a font that will include the tick symbol. Times New Roman does NOT include this symbol. One font to use is […]

[Continue reading…]

Reader Question: Showing and Hiding Themes [OpenOffice & LibreOffice]

show-hide-themes

Jerry left a comment saying that he had trouble with the following: “cannot find how to show/hide themes in calc” Thanks, Jerry. I’m not sure if this is exactly what you mean, but some refer to the Gallery in OpenOffice as ‘themes’. (Please leave a comment below if this is not what you meant.) To show […]

[Continue reading…]

Beautiful borders and backgrounds in OpenOffice [or LibreOffice]

Table properties box

I received the following query from Melissa: How do I create page borders that are nice, like ivy leaves or coloured swirly lines? All I can figure out are the straight black border lines. Thanks, Melissa. Personally, I’ve found that the border tool is generally only for variations on the straight border as you have […]

[Continue reading…]

Spell check does not work for Mac 2011

ms-mac-spellcheck-methods

If you are having difficulties with spell check Mac in the new Office 365 suite, then it’s probably no surprise – especially if you’re not using Windows and not in the US. However I find that the advice provided on the MS website is actually working for me, so I’d suggest running through the first […]

[Continue reading…]

Quickly See All the Formulas in Excel with This Shortcut

20131108-083027.jpg

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

[Continue reading…]