While I was working on a pretty big spreadsheet today I needed to see the data on rows as I was working on. I would be over in column J and wanted to see what data was in columns B and D. I thought if there was a way I could highlight the row that I was working with it would make it soo much easier.

After some searching I found this video below. It’s pretty easy to follow and was a life saver for my eyes and made going through my data much easier. This is a feature that Microsoft should incorporate into the next release of Excel. Enjoy!

If you have any questions or problems getting this to work let me know.

Came across this error today on a computer that would connect to the internet just fine but when you tried to go to another page you would get this error message. After a little troubleshooting I was able to find a quick and easy fix for this. Here are the steps to fix this problem. 

1) Open up Interet Explorer and then go to tools > internet options.

2) Click on the Connections tab.

3) Now click on the button that says “Lan Settings

4) Place a checkmark on “Automatically detect settings.”

5) Now click OK and then click on OK again to close the settings box. Close out Internet Explorer and open it back up. You should be able to go to any webpage and not get this error anymore.

I hope this helps you and if you still have problems let me know and I can give you some other things to try.

I just wanted to give a brief overview of what malware is and the difference between this and viruses. Malware stands for malicious software and is software that gets installed on your computer without your approval. Malware is a general terms that is often used to describe all of the spyware, worms, viruses, and pretty much just about anything else that is created to mess up your computer and steal information off of it.

Viruses are programs that can replicate themselves and try to infect more than one computer. It is designed to spread itself onto more computers and wreak havoc this way. Some viruses will try and delete files or corrupt system files to render your computer inoperable. In general viruses try to wreak havoc and “break” your computer by changing or deleting files.

In my next post I will go over the steps I take to clean and repair a computer that has malware on it.

RG

I just read an article today that I thought I would share with you in case you haven’t heard. If your computer is infected with the DNS Changer malware your computer will not be able to access the internet on July 9th, 2012. The FBI is going to prevent computers infected with this virus from accessing the internet.

The DNS changer trojan horse surfaced in 2007 and had infected millions of computers both PC and Mac. It would redirect you to hacked websites and kept your computer from updating or using your antivirus programs.

To see if you are infected with this virus go to http://www.dns-ok.us/ and if your computer is infected you can run a repair tool from Avira at http://www.avira.com/en/support-for-home-knowledgebase-detail/kbid/1199

If you have any questions or have trouble getting rid of this virus please let me know and I would be more than happy to help. But you need to act soon as July 9th is fast approaching.

RG

If you have having trouble updating your iPad or iPhone to the new iOS 5.1.1 here is a quick tip that should fix the problem of not downloading the update.

Go into your wifi settings and change the DNS server to 8.8.8.8

Now try and download the update again. If should work now and take about 20 minutes (depending on your connection speed) to download. Its about a 200mb update and once downloaded will take about 8 minutes to install. Once installed it will restart your device.

I would also check your apps to see if there are any updates for any of them.

RG