Loading...

Excel: Convert column to hyperlink

========= QUESTION ——— I have a spreadsheet full of web and/or email hyperlinks, but some do not show as hyperlinks. How do I convert them?   ========= ANSWER ——— =HYPERLINK("mailto:"&A1, A1) =Hyperlink(A1)   ========= EXAMPLES ———   ========= APPLIES TO / KEY WORDS ——— Hyperlink Auto Create Hyperlink   ========= REF ——— — http://anySiteSupport.com http://anySiteHosting.com

By |2015-07-06T16:23:21+00:00July 6th, 2015|Computers, Excel, Microsoft|Comments Off on Excel: Convert column to hyperlink

Adobe: Download installer file

========= QUESTION --------- I am trying to install Adobe Reader (Adobe Acrobat Reader), but their fancy installer routine keeps failing. How do I just download the installer file as a whole to install manually?   ========= ANSWER --------- http://get.adobe.com/reader/enterprise/   ========= EXAMPLES ---------   ========= APPLIES TO / KEY WORDS --------- Adobe download reader Acrobat [...]

By |2015-03-20T08:39:40+00:00March 20th, 2015|Adobe, Computers, Documentation|Comments Off on Adobe: Download installer file

Smartermail: Whitelist an email address

========= QUESTION --------- I have a contact I correspond with regularly that I would like to whitelist, or avoid spam filtering. How do you whitelist a particular email address?   ========= ANSWER --------- Logon to webmail (click here for an article on how to) Click the settings gear at the lower left Under My Settings, [...]

By |2017-12-01T23:47:24+00:00March 6th, 2015|anySiteSolutions.com, Email|Comments Off on Smartermail: Whitelist an email address

Office 2013 or Office 365 uninstall

========= QUESTION --------- How do I uninstall Office 365 or Office 2013?   ========= ANSWER --------- See REF   ========= EXAMPLES ---------   ========= APPLIES TO / KEY WORDS --------- Office2013 Office365 O365   ========= REF --------- http://support.microsoft.com/kb/2739501   --- http://anySiteSupport.com http://anySiteHosting.com

By |2015-02-16T06:55:35+00:00February 16th, 2015|Computers, Documentation, Microsoft, Office Suite|Comments Off on Office 2013 or Office 365 uninstall

MSAccess VBA: Compact and Repair Database

========= QUESTION --------- Is it possible to Compact and Repair a Microsoft Access database from VBA?   ========= ANSWER --------- The short answer is no. HOWEVER - we were lucky enough after much research to stumble across an obscure forum post discussing how to do it via simply sending keys via VBA! See Examples.   [...]

By |2017-12-01T23:47:24+00:00January 21st, 2015|Access, Computers, Documentation, Microsoft, VBA|Comments Off on MSAccess VBA: Compact and Repair Database

OS X WiFi Issues

========= QUESTION --------- Ever since I upgraded to OS X Yosemite, and iOS8, WiFi has been ridiculously buggy and slow on my Mac. Is there a fix for this?   ========= ANSWER --------- The best fix we have found for this, and honestly, have not seen the greatest success with it is to run the [...]

By |2015-01-12T14:57:28+00:00January 12th, 2015|Apple, Computers, Documentation, iOS, Mac, Networking, Wireless|Comments Off on OS X WiFi Issues

OS X: Substitute Text In Documents

========= QUESTION --------- In OS X Yosemite, every time I type two dashes in a row, or --- or ---------, it automatically converts it to a long dash, or EM Dash. How do I change this auto correct?   ========= ANSWER --------- In older versions of OS X (Mavericks), all you had to do was [...]

By |2017-12-01T23:47:24+00:00December 17th, 2014|Apple, Computers, Documentation, Mac|Comments Off on OS X: Substitute Text In Documents

WordPress: Unable to Log In, Cookies Are Blocked Due To Unexpected Output

========= QUESTION --------- Every time I try to logon to my Wordpress site, I get the following error: "Unable to Log In, Cookies Are Blocked Due To Unexpected Output" How do I fix this, or work around it?   ========= ANSWER --------- Believe it or not, this is due to the wp-config.php file being saved [...]

By |2014-12-15T10:32:29+00:00December 15th, 2014|Documentation, Internet/Web, WordPress|Comments Off on WordPress: Unable to Log In, Cookies Are Blocked Due To Unexpected Output

Windows password policy settings

========= QUESTION --------- While not part of a Windows Domain, can we enforce complex password requirements on individual user machines?   ========= ANSWER --------- Yes - simply use the Local Security Policy tool on the individual Windows machine. http://windows.microsoft.com/en-us/windows/change-password-policy-settings#1TC=windows-7   ========= EXAMPLES ---------   ========= APPLIES TO / KEY WORDS --------- Complex Password High Security [...]

By |2014-11-09T11:22:45+00:00November 9th, 2014|Computers, Documentation, Microsoft, Windows|Comments Off on Windows password policy settings

OS X Copy Path

Is there a way in OS X to be able to right-click and select an option to copy the path of the current file or directory? I would find this very helpful for when I am trying to quickly save a file to a particular directory and I can quickly find that directory in Finder, [...]

By |2017-12-01T23:47:24+00:00August 10th, 2014|Apple, Computers, Documentation, Mac|Comments Off on OS X Copy Path
Go to Top