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

Contextures Blog: In an Excel Order Form, click the check box and a macro fills in the billing address. Clear the check box to clear address info.

FILTER Function: Simple Excel FILTER function examples - how to create lists that update automatically. Set rules, format list items. Sept 15, 2020

Pivot Table Blog: Quickly refresh all pivot caches in workbook with #Excel macro. Message shows cache and failure counts. Sept 9, 2020

Excel Newsletter: Read the latest issue - Dynamic lists, check box trick, and more. Don't miss the next issue - sign up to get it by email. Sept 22, 2020.

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.

Latest Contextures Video

In Excel for Office 365, you can use the FILTER function to create dynamic lists, based on your criteria. These lists will update automatically, if you change the source data or the criteria. In this video, see 3 FILTER function examples:

1. Create a list of cities in a specific region, sorted A-Z.
2. Create a list of cities and sales reps in a specific region, with both items sorted A-Z.
3. Create a filtered list using 2 criteria - region and sales price.

See the details, and get the sample workbook on the FILTER Function Examples page.

Previous News

Contextures Blog: Use the new Excel TEXTJOIN function to combine several text items, quickly and easily. See simple and complex examples. Sept 3, 2020

Workbook Macro: At end of work day, use this macro to list and close all open Excel files. Next day, click button to open those files again. Like Excel's old Workspace feature. August 27, 2020

Criteria List: Filter an Excel table based on criteria lists on different sheet. Click buttons to quickly run macros that apply AutoFilter, or clear all filters. Get the free workbook. August 24, 2020

Contextures Blog: Click a Slicer to quickly show value groups in Excel pivot table. Great for source data with lots of value fields. August 20, 2020

Drop Down Lists: Limit choices with dependent drop down lists, based on choice in other drop downs. Select region, then sales rep, then customer for region and rep. Free Excel workbook. August 14, 2020

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