Excel Tips
May 11, 2017
How to debug an Excel VBA macro that is not working. There are amazing tools in Excel VBA that let you see the current value stored in variables as you step through code one line at a time. If you have a macro that is not working,
Workbook Opens on Missing Monitor »
May 10, 2017
An Excel workbook opens, but you can't see it! The taskbar says the workbook is open, but it is not on the screen. This recently happened to me when I opened a workbook that I last opened three years ago when I had a second monitor.
May 9, 2017
Excel VBA Macro to sort data. I don't like how the macro recorder creates extra code for sorting. Sorting in Excel VBA should be simple. One line of code, with the column to sort, which way (ascending or descending) and is there a header.
May 7, 2017
Today's trick from Lisa in Indianapolis is a faster way to filter a chart
May 5, 2017
Can Excel VLOOKUP return all results and join them with a comma in between?
May 4, 2017
A faster way to build an Excel 3D formula, also known as a spearing formula. I usually type =SUM(Jan:Dec!H10), but you can do this using the mouse.
May 3, 2017
The asterisk and question mark can be used as a wildcard in the Find dialog. But what if you actually want to find something that says 2*3 and not 2something3? There is a tricky way to tell Excel that you are really searching for an asterisk or a question mark.
Slimming Selection Post Merge »
May 3, 2017
Merged cells are evil. I often am selecting a range of data, but then accidentally touch a merged cell. Bam! My selection rectangle just became three columns wide. I usually curse and start selection again, but there is a keyboard shortcut to narrow the selection back to the original width.
Prevent Scientific Notation on Import »
May 1, 2017
Stop Excel from converting your data to scientific notation when you import data from a CSV or TXT file.