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.

Excel 2007 takes a long time to open files

June 13, 2011
2 Comments

So today I came across an odd problem where excel 2007 was taking anywhere from 30 seconds to a minute to open files.  The weird thing was that if the excel program was already open it would open up the files quickly, so I knew it had to be excel 2007 and not the files.  So after digging around the internet and trying mutliple things I came across the solution.  Its an easy fix.

Perform the following steps below. 

1.      Click on Start and go to settings and click on Control Panel.

2.      Double click on Folder Options and select File Types tab.

3.      Select XLS file type extension and click on Advanced.

4.      Highlight Open under actions and click Edit.

 In the dialog box that appears you need to make two adjustments:

1) At the end of the line after /e append a space character followed by “%1” (including the quotes)

2) Uncheck “Use DDE”.

3) Now Click OK three times to close out all the windows.

Now try and open up one of your excel files and it should open up quickly.