A fast way to close all workbooks in Excel
Month: February 2019
Excel Subtotal 9 versus 109 – Episode 2269
A Power Excel audience member in Omaha asked about the difference between 9 and 109 in the Excel SUBTOTAL function.
Excel VBA Macro to TRIM Selection – Episode 2268
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
Excel Power Query Move To Beginning – Episode 2267
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
Excel Power Query Column From Examples – Episode 2266
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.
Refreshing Stock Data In Excel 2265
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.
Refreshing Stock Data In Excel 2265
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.
Excel Data Types Geography 2264
A second look at the new Geography Data Types in Excel.
Excel Slicer Selections In Title 2263
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.
Excel Ctrl Click to Unselect Cells – 2262
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.
Pivot Table Filter Between Two Dollar Amounts – Episode 2261
Myrna from El Paso Texas wonders how to create an Excel pivot table that only shows customers between $10K and $100K.
Excel Artificial Intelligence With Ideas
Find interesting trends in your Excel data using the new artificial intelligence feature called Ideas.