MrExcel Excel Videos

Kristin wants to have a fast way to remove leading a trailing spaces from an entire range of Excel cells. In this episode, a 7-line macro to solve this problem. Sub TrimSelection() Dim cell As Range For Each cell In Selection If Not cell.HasFormula Then cell.Value = Trim(cell.Value) End If Next cell End Sub

How to move a column to the beginning of a data set in Excel Power Query. How to Group and summarize data in Excel Power Query

Flash Fill in Excel 2013 was a neat party trick. But the Column From Examples feature in Excel Power Query is far better. See how Column From Examples works.

Some tricks with the new Stocks data type in Microsoft Excel. How to refresh the current stock price in Excel. How to change the Stock Market Exchange for one security.

A second look at the new Geography Data Types in Excel. Geography is just one example of how Excel can use data types now and in the future.

When you filter a pivot table to many items, the title of (Multiple Items) is nearly useless. Which items? Printing the whole slicer can take up a lot of space. Today, I combine a Mike Alexander trick with TEXTJOIN to create a title that shows which items are selected in the slicer.

You are selecting multiple ranges in Excel using Ctrl. Then, you accidentally click some cells that should not be in the selection. Previously, you would have to start over. Now, you can Ctrl+Click to Unselect if you are using Office 365.

Myrna from El Paso Texas wonders how to create an Excel pivot table that only shows customers between $10K and $100K.

Find interesting trends in your Excel data using the new artificial intelligence feature called Ideas.