Useful Excel for Mac Keyboard Shortcuts

Like so many others I am a regular Excel user but having grown up on Windows finding equivalent keyboard shortcuts for the Mac can sometimes be a pain. Specifically how to manipulate cells.

So presented here as an aide memoir for me and hopefully it will prove useful to others:

Ctrl + u – edit a cell

Cmc + Alt + Enter – new line in cell

Enter – move to next cell below

Shift + Enter – move to next cell above< … Read the rest

Crapware, courtesy of Oracle Corp.

I thought that the practice of forcing useless software onto users as part of an installation had died out but apparently not by the looks of this Java installer.

That this is being foisted upon us by Oracle, who clearly don’t need the little money they must be making from this, is a surprised as I thought this practice was restricted to smaller outfits but clearly not.

If you want to help stop this practice you can sign a petition at change.org here. … Read the rest

Opening Links in Evernote Client rather than Web

Despite all it’s foibles Evernote remains one of my most used apps and being able to link to it from elsewhere, such the task app I use, adds enormous benefit.

At one point you used to be able to generate links that when clicked would open up in the desktop app, these started evernote://. At some point these were lost and the link generator in the client only returned http:// links meaning that the request opened in the web site app. Problem with this is that it is slower and I usually have to authenticate again to get access.

I … Read the rest

Resolving “Error 1 – Operation not permitted.”

Trying to unpack a zip file this afternoon I kept coming across the error message “Error 1 – Operation not permitted.”. When I have had this before I have just switched from the default Archive app to Keka or Stuffit Expander and all has been good but for some reason that wasn’t working on this zip file.

Then I cam across the following tip on Stack Exchange. Drop into a terminal session, change to the directory with the zip file and run this command:

jar xvf <zip file name>

It worked a treat. Give it a go next time … Read the rest

Windows 10 Preview

I finally got round to downloading and installing the Windows 10 preview this morning to allow me to test our web app with it and the latest version of Internet Explorer. I had also wanted to take a look at Project Spartan but it seems that isn’t available yet.

Like so many others I wasn’t a great fan of Windows 8 but based on the very brief look this morning Windows 10 is a vast improvement on what went before. The start menu has been restored and the titles are not incorporated and it’s not a bad look.

Windows_10_Technical_Preview__English_

There is … Read the rest

2 Great Apps to Help you Show and Tell

Working in a small business you have to get involved in all sorts of areas that might be outside your core skill set. In my case that includes producing training material to help our clients understand our products better. In order to make that as painless as possible here are a couple of great apps that I use.

Clarify

clarify_camera

Producing documentation with screen grabs can be a real chore and while it is possible to use something like Microsoft Word it is much, much easier to do with Clarify.

The beauty of the app is the way that it lets … Read the rest

Why I can’t get my Head Around Evernote’s Work Chat Feature

In the last major release of Evernote a new feature called Work Chat was introduced. It is described by Evernote as allowing you to “discuss your work in Evernote, in real time, with the people who help you get it done.”. So it is sort of like an inbuilt chat facility and as that it works as described.

The problem is that what is the most natural thing to want to do while chatting over a note? For me it is to update it with the other party and for both to see the updates but when you do that … Read the rest

Can you have too much cloud storage as Microsoft offers unlimited space?

Recently Microsoft announced that everyone with an Office 365 subscription would be granted unlimited storage on OneDrive, their Dropbox and Google Drive competitor. If it doesn’t seem long ago that they bumped up the storage from 15gb to 1tb then it’s not, because that announcement was made just last June.

On the face of it this seemed like great news – all the space to store whatever you want. However, the reality is somewhat different. Firstly this is a syncing service (as they all are) and so the absolute maximum you can sync is the size of your hard drive … Read the rest

A Potentially Dangerous Experiment

Being mobile means I have to work in a number of different places on a number of different machines. The one constant is that no matter where I am I want and need to have my files with me. While I have Dropbox and Google Drive and and iCloud and Box and OneDrive and OwnCloud accounts I found that files that were in the Documents and Downloads folders on my iMac weren’t available to me on the move.

This led to a light bulb moment. What if I could store my Documents and Downloads folders in cloud storage? And so … Read the rest

Internet Explorer (the joke)

My son sent me this today:

Internet Explorer users at risk from major bug

“All four users have been informed” a source said.

I thought that it was a joke until I subsequently saw this. (Obviously it is a joke but the problem clearly isn’t).

While IE usage is not as high as it once was it it still high enough that this is going to affect many people, particularly as the bug seems to be in versions 6 through 11.

Setting aside the issue itself this, and the recent Heartbleed bug, highlights just how easy it is for … Read the rest