What's New in Microsoft Excel

Here is the latest news about Microsoft Excel, and updates on the Contextures website and blogs.

Also see: Excel Events || RSS || Excel Humour || Debra D Blog

New on Contextures

Pivot Table Blog: Analyze sales data with Pivot Table Top 10 filters. Change settings on worksheet, macro changes multiple pivot table filters automatically. Apr 7, 2021

Contextures Blog: How to fix Excel error, Cannot Shift Objects Off Sheet or Can't push objects off sheet. Simple shortcut, or make small change to comments. Apr 1, 2021

Conditional Formatting: Use Excel conditional formatting to automatically change currency symbol in worksheet numbers, based on country name selected. Mar 31, 2021

Data Validation: Use simple data validation rules to limit budget entry amounts that can be entered in Excel budget plan. Video, written steps, free Excel workbook Mar 23, 2921

Excel Newsletter: Read the latest issue - Hide used items in drop down list, currency symbol switch, and more. Don't miss the next issue - sign up to get it by email. Apr 6, 2021.

Also see: Excel Events || Excel RSS || Excel Products

Excel - What's New

To see the latest features and fixes in Excel, go to these pages on the Microsoft site and YouTube.

Microsoft 365 Apps: For the Monthly Enterprise Channel, go to this page for a list of new features and fixes in the latest versions.

Microsoft 365: To see new features demonstrated, go to the Microsoft 365 YouTube Channel. Look for the monthly videos on "What's New".

Excel Improvements: Excel users are encouraged to post improvement suggestions on Microsoft's Excel UserVoice website. To see the completed items from that list, go to this filtered list. There's also a list in this Excel Tech Community article, which is frequently updated.

Office Updates: For a list of all Office updates, going back to 2010, and other Microsoft resources, visit the Office Updates page. There is a Download PDF link, at the bottom left corner on that page.

New Contextures Video

Watch this short video to see how to change the number format in a pivot chart, either on its own, or with the pivot table's number format.

See the details, and get the sample workbook on the Pivot Chart Format page.

Previous News

Contextures Blog: Quickly create PowerPoint slides from data in Excel list, using these macros. Mar 18, 2021

Excel Error: See how to fix the Excel Errors, Cannot Shift Objects Off Sheet or Can't push objects off sheet. Use a simple keyboard shortcut, or make a small change to the comment settings. Video, written steps. Mar 16, 2021

Pivot Table Blog: Show differences between pivot table amounts without formulas. Use this built-in Excel feature. Mar 10, 2021

Contextures Blog: Keep Excel IF formulas short & simple! Do you have IF formula horror stories? Mar 4, 2021

Don't Miss Our Excel Tips

Don't miss my latest Excel tips and videos! Click OK, to get my weekly newsletter with Excel tips, and links to other Excel news and resources.

What's New in Microsoft Excel