Task Manager
Wow - if you right click the Taskbar (bottom of the Windows screen) you can access the Task Manager. No more Ctrl + Alt + Del - woohoo!
Hyperlink with Search
I wrote a post in 2016 about using INDEX and MATCH to create a hyperlink based on a search result. I thought I would update the technique using XLOOKUP.
(more…)Excel Power Query Saving Issue
There was a recent discussion of this topic on LinkedIn. When you are in the Power Query window you can’t save the query. If you Close and Load and Excel crashes, you could lose your work. If you have spent some time working on a query this can be frustrating. Here’s how you can capture the query before using Close & Load.
(more…)A Cell Reference Custom Function
The formula to return a cell reference is quite long. This makes it an ideal candidate for a custom function.
(more…)Browser Mouse Tip
In a browser you can open a link in a new tab by middle clicking - (click the mouse wheel) - the link. Woohoo!
Date Alignment Trick in Excel
Text alignment in Excel is versatile. If the column isn’t wide enough to display the text, it will display over the next cell. Date and number alignments are not so forgiving. If the column isn’t wide enough the cell with display the ### symbols or the scientific format. Here is a function technique to get around the limitation.
(more…)Number Formats in Excel
When you link to a cell that has a number format you may be surprised to learn that as well as the value that is linked, the format also is updated based on the cell you linked to.
(more…)