FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week


Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

August 23, 2016

Hi fellow Excel Addict,

T
urns out that my computer problem wasn't as bad as I feared. Finding the solution was the biggest problem.

It wasn't a computer crash or anything that disastrous. On Tuesday, Windows did an update to my PC and my Office 2013 programs, except for Outlook, stopped working.

N
ow what's worse than an Excel Addict who can't access Excel?

Anyway, after some online searching, I narrowed down the problem to my StarTech 
external USB video adapter (USB2VGAE3) which I am using to display a 3rd monitor. Turns out that because 'hardware graphics acceleration' was enabled in my Office programs, the updated driver was preventing my Office programs from opening. Once I disabled the setting under Outlook, Options, Advanced, everything worked just fine.

Disable Hardware Graphics Acceleration in Microsoft Excel 2007 2010 2013 2016 365
Now I'm back in business. Thank you for your patience.

If you missed last Thursday's 'Excel in Minutes' tip, 'Use Custom Views to Print Letter And Legal Pages From The Same Worksheet', you can read it here now.

Do you find my Excel tips helpful? Please feel free to share my newsletter with your friends — chances are they will too.

Wishing you a great week end keep on Excelling,
Francis Hayes (The Excel Addict)
Email: 
fhayes[AT]TheExcelAddict.com



TheExcelAddict.com Quote of the Day

"Our job in this life is not to shape ourselves into some ideal
we imagine we ought to be, but to
find out who we already are and become it.”

-- Steven Pressfield, The War of Art --



If you missed my last newsletter, you can click here to view it online.



Excel in Seconds with TheExcelAddict.com

Resize the Filter Dialog to Display Long Text Values

When you use Excel's Filter (Data, Filter) and your list contains items that are too long to display in the dialog, choosing items to filter can be difficult.

Long text not visible in Autofilter Dialog in Microsoft Excel 2007 2010 2013 2016 365
The filter dialog contains a horizontal scroll bar which you can use to view the part of the text not visible on the right, however the text on the left scrolls out of view.

Scroll Long Text Filter Dialog in Microsoft Excel 2007 2010 2013 2016 365
You may not have realized that this dialog box can be resized. On the bottom right corner there are three small dots indicating that the dialog can be resized.

Resize Auto Filter Dialog in Microsoft Excel 2007 2010 2013 2016 365
Click and drag this corner to make the dialog wider and longer. That will make it easier to see more of the items in your list.

Resize Autofilter List Dialog in Microsoft Excel 2007 2010 2013 2016 365
Unfortunately, once you close the dialog, it reverts back to the default width, so you need to resize the filter dialog each time.

I guess this is another of those "What were they thinking?" missing features.


FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week


Thanks for supporting this newsletter and website

Earnings Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that for a few dollars. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are ever not completely satisfied with anything I recommend, please let me know and I will get your money back for you...GUARANTEED. You can't lose.
 'Spreadsheets Tips From An Excel Addict' and 'Excel in Seconds' are publications of TheExcelAddict.com.
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630