Excel Tips
July 6, 2017
The fill handle is great for Months, Weekdays, Quarters, and Dates, but why won't it fill 1, 2, 3? This episode shows many workarounds. Also includes:
July 6, 2017
Kuldeep needs to select every third cell through a range of 1500 cells. MrExcel provides a crazy solution.
July 5, 2017
Create ad-hoc totals for an Excel data set where you will be filtering the data. Also in this video: Using SUBTOTAL(109,) for summing data that has been manual hidden rows. Using Ctrl+Ditto to copy the exact formula down one row.
July 4, 2017
There is a faster way to use the Filters in Excel. It is reminiscent of Filter by Selection from Access, but called AutoFilter in Excel. You will have to customize the Quick Access Toolbar to find the command.
July 3, 2017
Tip #1 from the MrExcel XL book - fast ways to copy a formula down a column.
Split Workbook by Worksheets »
July 1, 2017
You have a workbook with many worksheets. You want to send each worksheet to a different person. Today, a macro to split that data out.
June 30, 2017
Regular pivot table filters offer the Show All Report Filter pages, but Slicers do not support this functionality. Today, some VBA to loop through all possible slicer combinations.
Learn Excel Conditional Format Mixed References »
June 29, 2017
Setting up a conditional formatting formula that uses a mixed reference. Most conditional formatting formulas require an absolute reference. But this spreadsheet to track trucks in a yard requires
Sync Slicers from Different Data Sets »
June 22, 2017
Slicers are awesome for pivot tables because you can control multiple pivot tables from one set of slicers. But - that is sort of a lie. You can control multiple pivot tables that came from the same data set. When you have pivot tables that came from two different data sets, it is pretty tricky. I will show you some VBA that will let you pull this off.