August 23, 2016
Hi fellow Excel Addict,
Turns 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.
Now 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.
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)
If you missed my last newsletter, you can click here to view it online.
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.
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.
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.
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.
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.
| 'Spreadsheets Tips
Excel Addict' and 'Excel in Seconds' are publications of
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630