MrExcel Excel Videos

Magic: Create Title with Excel Slicer Selections! - 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.

View full article »

Suddenly it's Here: Unselect Cells in Excel - 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.

View full article »

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.

View full article »

Excel Artificial Intelligence With Ideas - 2260

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

View full article »

Excel Pivot Table Fill In Empty Cells 2259

Three Excel tricks today: Fill in the empty cells when you have multiple row fields in a pivot table. Fill in the empty cells because there were not any sales. And Change the Pivot Table Defaults for all future pivot tables.

View full article »

Excel Document Location - Episode 2258

An awesome trick from Candace & Robert in Topeka of how to copy the path to your workbook using Document Location on the Quick Access Toolbar in Excel.

View full article »

Excel Fill Text On Subtotal Rows - Episode 2257

Revisiting a topic from Episode 1995 - how do you bring the customer name field down into the subtotal rows? Kimberly from Oklahoma City and Sarah from Omaha collaborate for a faster way.

View full article »

Excel Fill Monday Weds Fri Dates - 2256

There is a well-known trick in Excel to fill just weekdays. But what if your work week is not Monday through Friday? Today, a trick with WORKDAY.INTL in Excel to fill Monday, Wednesday, Friday.

View full article »

Excel Filter to Over $20K - Podcast 2255

An awesome tip from Kris and Taylor in New Mexico - how to use the AutoFilter to filter to all rows above $20K in Excel.

View full article »