Monthly Archives: December 2014

Want to illustrate an Excel worksheet with a pop-up picture?

Would you like to be able to illustrate one of the tables in your Excel worksheet, like this user?

Pop up images in Excel

This picture is hidden within a cell “comment” which allows it to only pop-up when you place your mouse over the cell – cool, eh?

Here’s how to do it ….

  1. Right click on a cell and select Insert Comment
  2. Delete the user’s name
  3. Hover the mouse over the comment’s border until it becomes a four-headed arrow
  4. Right-click and select Format Comment
  5. Click on the Colours and Lines tab
  6. In the Fill section, click on Colour, then Fill Effects.
  7. Click on the Picture tab and then select your picture
  8. Click OK to insert it

 ~~~

If you enjoy this article, please click on “Like” to let me know – and/or write a comment below 🙂

Desktop PC running out of USB ports?

If you don’t have enough USB ports for your needs, there may be no need to struggle any more.

You can often add 4 into a spare slot inside your PC (as most computers have a spare ‘PCI slot’). 

Here’s a photo of a card which is easy to buy, fit and setup…*

IMG-20141220-00358* Click here Startech.com 7 Port (4 External, 3 Internal) PCI USB Card Adapter to view one currently on sale

 ~~~

If you enjoy this article, please click on “Like” to let me know – and/or write a comment below 🙂

USB ports too close together?

If you find it tricky to plug items into your computer’s USB ports, you can purchase an extension lead to make it much easier.

Here’s a picture of a short one I use ….

IMG-20141220-00357

Click here StarTech.com 6 inch M/F USB 2.0 Extension Adapter Cable A to A to view one currently on sale

 ~~~

If you enjoy this article, please click on “Like” to let me know – and/or write a comment below 🙂

Sound connections becoming faulty?

If your sound sockets are become faulty, you can replace them with ones which plug into a USB socket. Here’s a picture of an adapter:

usb sound card

They replace the sound card built into your laptop, providing replacement headphone/speaker and microphone sockets.

Being on a USB connection, they can of course be used with desktop PCs, but are ideal for laptops/netbooks because of the high cost and hassle of replacing their built in sound card (where it’s possible).

Click here BUY ONE GET ONE FREE USB2.0 External High Quality 3D 7.1 Channel Audio Sound Card Adapter for MIC to view one currently on sale for less than £5; however more expensive ones may give better quality.

 ~~~

If you enjoy this article, please click on “Like” to let me know – and/or write a comment below 🙂