fixed : USB-C memorystick for iPad Pro

Question :

I have an iPad Pro 2018 with a USB-C port, and I found out that I can connect a regular USB-stick using a USB-to-USB-C-adapter and then browse and use all files on the USB-stick from within the Folders.app on my iPad Pro. That’s great !

Now, since I only have USB-C ports on both my MacBook Pro and my iPad Pro,  I was wondering : are there any good USB-C memory sticks available for an affordable price ?

 

Answer :

The answer is simple : Yes, there are USB-C memorysticks that work great.

We have tested this one, that is both USB-C and USB compatible, that makes it even more versatile :

Topesel USB-C Memory Stick : buy it on Amazon UK / Amazon DE

And there are several alternatives (that we didn’t test) :

SanDisk Ultra Dual Drive Go USB-C : buy it on Amazon US / Amazon UK / Amazon DE

Verbatim Store&Go USB-C Flash Drive : buy it on Amazon US / Amazon UK / Amazon DE

Kenix on-the-go USB-C Memory Stick : buy it on Amazon UK / Amazon DE

Kootion USB-C Memory Stick : buy it on Amazon US / Amazon UK / Amazon DE

Meco Eleverde USB-C Memory Stick : buy it on Amazon US / Amazon UK / Amazon DE

Meco Eleverde 2-in-1 USB-C Memory Stick : buy it on Amazon US / Amazon UK / Amazon DE

enjoy 😉

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)