Excel Tips
F2 Stops Excel RefEdit Boxes From Inserting Cell Addresses »
August 20, 2014
Maybe you are setting up Conditional Formatting, or defining a Name. It could be any dialog where you have a RefEdit control (the boxes with the red arrow at the right). You mis-type something and instinctively press Left Arrow Left Arrow Left Arrow to correct it. But Excel starts inserting cell addresses instead of moving left.
Add a ToolTip to Any Cell in Excel »
August 19, 2014
ToolTips are awesome, right? You see them all the time in the Ribbon. If you are creating a worksheet for someone else to use, why not add reminders and notes to the cells they are supposed to fill out?
Rearrange Just One Row in Excel »
August 18, 2014
You have one row out of place in Excel. Sorting seems like a hassle. Is there a fast way to sling the row to the right place?
August 15, 2014
Need to remove duplicates in Excel? Excel 2007 introduced the Remove Duplicates command on the Data tab of the ribbon.
Secret DateDif Function in Excel Calculates Years, Months, Days »
August 14, 2014
Sometimes, you need to show each employee’s age in Years and Months. The cool|secret|sometimes buggy =DATEDIF function does the trick.
Wish Excel Had AutoAverage Like AutoSum? »
August 13, 2014
It already does! Open the tiny dropdown arrow next to the AutoSum icon, and you have AutoAverage, AutoMax, AutoMin, and AutoCount!
Copy the Quick Stats Values to the Clipboard »
July 10, 2014
The question came during an Excel seminar in Tampa: Wouldn't it be cool if you could copy the statistics from the status bar to the clipboard for later pasting to a range?
Learn Excel - "Charting Improvements in Excel 2013" »
June 17, 2014
Is your Excel work 'Chart Heavy'? Do you do a lot of Charting in Microsoft Excel? Curious about Charting in Excel 2013? Well, MrExcel is here to tell you that Charting improved greatly in Excel 2013, with new features like Recommended Charts, easier Combo Charts, and Chart Labels from Cells.
Cloud Computing is Dangerous when You don't Own the Cloud »
February 5, 2014
Cloud computing is dangerous when you don’t own the cloud. I learned that lesson again this week when Facebook removed the MrExcel.com page at Facebook. Gone are hundreds of Excel Q&A posts. Gone are event notices. Gone are the 2000+ fans who would be notified when I posted there.