Excel Tip: Highlight Row Cursor Is On

September 28, 2012
Leave a comment

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.

Internet Explorer Error: The Address Is Not Valid

September 27, 2012
3 Comments

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.