fixed : AirDrop from Mac to iPhone/iPad

Question :

I’ve just installed iOS 7 on my iPhone 5, and since I was reading about AirDrop being one of the new features, I immediately thought of using AirDrop to get this picture I just made onto my iPhone…

But when I turn on AirDrop on both my Mac and my iPhone, they can’t seem to see each other…

Is there any way to get this to work ?

Answer :

No – at least : officially not.

So far, AirDrop is only available on Macs with supported AirPort-cards running MacOSX 10.7 “Lion” or newer and on the iPhone 5 and newer running iOS 7…

Furthermore, AirDrop is only supported Mac-to-Mac or iPhone/iPad-to-iPhone/iPad…

Maybe this situation will change with the introduction of OSX 10.9 “Mavericks”, but for now there is no (official) option to use AirDrop from Mac-to-iPhone/iPad and vice-versa…

But…

There is an alternative that works the same basically : AirDisk Pro

(note : seems like Phone Drive and Phone Drive FREE are exactly the same app as AirDisk Pro, but at a lower price, even free…)

With this AirDrop-alternative, file transfer is very quick …and it’s even more compatible than the official AirDrop : the app can be installed on any iPhone or iPad running iOS 4.3 and the WiFi-connection can be made from any Mac or PC using a web browser…

In short, the app works like this :

– install the app on your iPhone/iPad

get AirDisk Pro
get Phone Drive FREE [stores max. 10 files]
get Phone Drive

– make sure your iPhone/iPad and your Mac/PC are on the same WiFi-network

– run the app

– enter the IP-address (or network name) that the app gives you as a URL in your Mac/PC’s web browser

– drag the file you want to transfer onto the webpage

done !

enjoy šŸ˜‰

Donate Button (MacManusNL)

Advertisements

fixed : copied Excel data only shows zeros instead of original values

Question :

I have this data-range in MS ExcelĀ that I want to copy from one page to another, but when I do, in the area that I want to copy to, all cells are filled with zeros…

…the original data has disappeared…

How can I fix this ?

Answer :

Just use the “Paste Special”-option from the Edit-menu, like this :

– in MS Excel, go to the data that you want to copy

– select the range of data you want to copy

– press CMD + C (or choose “Copy” from the Edit-menu)

– then go to the area you want to copy the data to, and select the upper-left cell of the area you want the copied data to appear in

– Ā then press SHIFT + CMD + V (or choose “Paste Special” from the Edit-menu)

– in the pop-up window that appears, select “Values” (the option third from the top) instead of “All” (which was the first option from the top), and click “OK”

– now the original data will appear

…that’s it !

Enjoy ! šŸ˜‰

Donate Button (all)

fixed : copy a row into a column (or a column into a row) in MS Excel

Question :

I have this column full of data in MS Office’s Excel, and now I need the exact same data range in another spreadsheet, but this time as a row…

Do I really need to re-type all data ?

Isn’t there an easier solution ?

Answer :

Yes, there is a far simpler way to copy data from a row into a column (and vice versa) in Excel.

You can just copy & paste, or “Paste Special” to be exact… it goes like this :

– in Excel, select the range of cells you want to use (or copy)

– then press the CMD + C key-combo (or select “Copy” from the Edit-menu)

– then go to the page (a.k.a. “sheet”) you want the copy the data to, and select the upper-left cell of the area you want the copied data to appear in

– then press the SHIFT + CMD + V key-combo (or select “Paste Special” from the Edit-menu)

– …and in pop-up window that opens, put a check-mark in front of “Transpose” and click “OK”

– now the data from your original row (or column) will ‘magically’ appear as a column (or row)…

…that’s it !

enjoy ! šŸ˜‰

Donate Button (all)

fixed : change the Currency-format of only a few cells in Numbers (from iWork)

Question :

I’m using the Apple Numbers spreadsheet-app (from iWork) and I want to use multiple currencies in one spreadsheet (US dollars, GB pounds and Euros). I tried “Create / Change Custom Cell Format” from the “Format”-menu, but there the currency is set to default to my local currency (Euros) and I can’t change it…

This must be possible, right ?

But, how do I do it ?

Answer :

The trick is you should change the currency format of a (group of) cell(s) in the “Inspector”…

Here’s how to :

– in Numbers, select the cell or cells of which you want to change the currency

– then click on the “Inspector” (info-sign shaped button on the right of the upper bar of the spreadsheet-window)

– in the “Cells”-window that opens, choose the tab marked “42” (*)

– there, under “Cell Format” you should change the default “Automatic” to “Currency” and choose the one you want to use

That’s it !

šŸ˜‰

(*) this is probably a subtile reference to “The Hitchhikers Guid To The Galaxy (H2G2)”, where 42 turns out to be the answer to “the ultimate question of life, the universe and everything”

Donate Button (all)

fixed : HP DeskJet 930c can’t print PDF

Question :

I got an eMail-attachment in PDF, and when I tried to print it from my OSX 10.8 “Mountain Lion” MacBookPro, a completely blank page came out of my HP DeskJet 930c…

And when I tried printing the entire mail (including the preview of the PDF), the eMail-bodytext got printed, but there was a blank spot where the PDF-preview should have been…

What can I do ?

Answer :

For some unknown reason, the HP DeskJet 930c seems to have problems printing PDFs from OSX 10.8 “Mountain Lion”. The only remedy seems to be to install Adobe Reader and print every PDF from there…

…to make printing from Adobe Reader a little easier for you (and something you will not forget when you do not print PDFs for some time), it would be good to set Adobe Reader as the preferred software to open any PDF on your Mac. To do so, do this :

– select any PDF-document’s icon on your Mac

– then press [CMD]+[I] on your keyboard

– in the ‘Get Info’ window that opens, go to the chapter called “Open with:”

– if the grey triangular arrow in front is pointing to the right, click on it to make it point downward and reveal the pulldown-menu that you can should choose “Adobe Reader” from

– after you’ve done that, make sure you also click the “Change All…” button

…now any PDF-document you get on your Mac or in your Mac will open up in Adobe Reader, and you can print it from there

That’s it !

Donate Button (all)

Enjoy !