Archive | High Tech RSS feed for this section

​What I Want in an e-Reader

With tablet PC’s now dominating the market, I still like the plain eReader. Sorry, an iPad won’t do it for me. However, thereafe some things I want out of an eReader. Everything would be “touch.” Larger screen. 10.1″ sounds about right! Page flow: When turning pages I want them to be as smooth and graphical [...]

Excel: My Spreadsheet Has a Font?

By default, Microsoft Office Excel 2007 uses the Body Font font in font size 11 (which is displayed as the Calibri font in font size 11 when you type data in a worksheet, header or footer, or text box) but you can change the default font and font size for all new workbooks that you create.

  • Click the Microsoft Office Button , and then click Excel Options.
  • In the Popular category, under When creating new workbooks, do the following:
  • In the Use this font box, click the font that you want to use.
  • In the Font Size box, enter the font size that you want to use.

NOTE: To begin using the new default font and font size, you must restart Excel. The new default font and font size are used only in new workbooks that you create after you restart Excel; existing workbooks are not affected. To use the new default font, you can move worksheets from an existing workbook to a new workbook. For more information, see Move or copy a worksheet.

Need a YouTube Desktop Uploader for Windows? Try This!

Having in some instances very large video files to upload to YouTube, I was looking for a desktop tool to upload YouTube videos. Google Video once had a nice, simple tool, as did YouTube once a very long time ago. Since then those tools were deprecated and we were forced to upload large videos through [...]

Microsoft Outlook Freezes and or Crashes When Opening Attachments

Let’s say you’re running Outlook 2007, are connected to a web server via POP, and it freezes/crashes when opening attachments. A solution to that problem would be to locate the “scanpst” utility, usually found here: Outlook 2010: C:\Program Files\Microsoft Office\Office14\scanpst.exe Outlook 2007: C:\Program Files\Microsoft Office\Office12\scanpst.exe Outlook 2003: C:\Program Files\Common Files\System\MSMAPI\<locale ID>\scanpst.exe Outlook 2002/XP: C:\Program Files\Common [...]

Removing All Hyperlinks in Excel

Removing a bunch of hyperlinks can be tedious. Imagine the time you have to spend right-clicking on each of those links and selecting ‘remove hyperlink’ on the context menu. Of course it would just take two clicks, but what if you are to remove a hundred of them or perhaps 1000 hyperlinks? I’m sure that [...]

Excel Macro – Get and Extract Hyperlink URL Address From Link

This has personally worked like a charm for me. Try this user-defined function: =ShowAddress(A1) Where A1 is the cell with the hyperlink in it. Here is the Macro function code: Public Function ShowAddress(rng As Range) As String If rng.Cells.Count > 1 Then ShowAddress = CVErr(xlErrValue) Else ShowAddress = rng.Hyperlinks.Item(1).Address End If End Function Note: With [...]

How to Create a Shortcut or Hotkey to Clear the Clipboard in Windows

  Have you ever copied something to the clipboard that you don’t want to leave there in case somebody else is going to use your computer? Sure, you can copy something else to the clipboard real quick, but can’t you just make a shortcut or hotkey to clear it? And of course you can, with [...]

Ubuntu – How to fix “Unhandled Error Lockdown” while attempting to mount an iOS 5 device

Being that at times I use a netbook for portability (the Macbook Air is too expensive), sometimes I would like to send multiple photos by email by connecting my iPhone 3GS smartphone to it, then moving the pictures. However, with iOS 5, until recently it was impossible to do as I was always getting the [...]

Apple’s “The Woz” (Steve Wozniak) has a new Toy – The Samsung Galaxy!

Last month The Woz (Steve Wozniak) was reported by Business Insider for buying an Apple iPhone 4S. Yesterday he was caught buying a Samsung Galaxy phone with Google’s Android operating system, Apple’s biggest Smart Phone competitor, straight from Google’s headquarters!                   I guess that he’s showing his [...]

R.I.P. Steve Jobs – Former Apple CEO Dead at 56 Years of Age

The world just lost a visionary in Steve Jobs today. At 56 years of age, Jobs battled numerous health problems and lost the battle on cancer. He will be missed. From a technology perspective, Apple’s mantra has been that “Apple innovates and everyone else imitates.” I find this to be true to an extent. During [...]