MrExcel Publishing
Your One Stop for Excel Tips & Solutions

MrExcel News


Excel Offers a New Sound Theme to Provide Feedback

Excel Offers a New Sound Theme to Provide Feedback »


Excel adds a new feature in July 2017 - Provide Feedback with Sounds. Go to File, Options, Ease of Access to find the new feature. Choose Modern as the Sound Scheme.

Next Invoice Number

Next Invoice Number »


Microsoft Excel offers many invoice templates that you can download. But there is no built-in way to increment to the next invoice number.

Split Workbook by Worksheets in Excel

Split Workbook by Worksheets in Excel »


You might have two reasons to want to split a workbook where each worksheet becomes a new workbook.

Sync Slicers in Excel

Sync Slicers in Excel »


How can you have a slicer drive two pivot tables if they came from different data sets? I recorded this video showing how to add a few lines of VBA code to your workbook to do this.