A fast way to close all workbooks in Excel
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.
Dim cell As Range
For Each cell In Selection
If Not cell.HasFormula Then
cell.Value = Trim(cell.Value)
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.