Home > Skills > FAQs > What's New What's New in Microsoft Excel On this page, you can see what's new, here on the Contextures website, and on each of my blogs. There's one of my recent videos too, showing the steps for an Excel feature. Also, there are links that take you to the Microsoft site, so you can find out what's new in Microsoft Excel, and the other Microsoft Office apps. For many more tutorials, go to the Excel Tips page. You'll find an Excel topic list there, with links to the tutorial pages.

New on Contextures

These are the latest articles that I've posted here on my Contextures site, as well as each of my blogs. There is a longer list of articles, further down on this page - it shows articles from previous months

Pivot Table Blog: Do you love Excel GetPivotData function or do you turn it off? . Mar 29, 2023

Unpivot with Power Query: Unpivot Excel data using Power Query, to create normalized column layout. Step-by-step guide, sample file. Mar 8, 2023

Contextures Blog: How to turn off the grey "Page 1" on your Excel worksheet. Mar 9, 2023

Debra D's Blog: Enter start and end dates on a Microsoft Access form, to use as date range criteria for a query. Mar 13, 2023

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 compare two Excel lists, to find new items in the second list, and add them to the first list

See the details, and get the sample workbook on the Excel Compare Two Lists page.

Previous News

This list shows previous articles that I've posted here on my Contextures site, as well as each of my blogs. These articles are from the past year or so.

Pivot Table Blog: Instead of complex Excel formulas, use a pivot table to show MIN IF or MAX IF numbers. Mar 15, 2023

Pivot Table Blog: How to fix Excel pivot table subtotal date format to match other dates. Mar 8, 2023

Contextures Blog: Calculate ratios in Excel with this 3-step formula, and don't trust the bots! Mar 2, 2023

Pivot Table Blog: Move Excel pivot table values for better printing, with a vertical layout. Mar 1, 2023

Filtered Rows: Count or sum filtered rows in Excel list. How many rows are visible in Excel table? What the total for numbers in filtered table. Feb 24, 2023

Contextures Blog: Use an Excel macro to quickly increase amounts in multiple cells. Feb 23, 2023

Pivot Table Blog: Select specific pivot table section, such as subtotals, so you can apply formatting. Video shows the steps. Feb 22, 2023

Contextures Blog: Macros list all threaded comments on an Excel worksheet. You can show all replies for each comment too! Feb 16, 2023

Pivot Table Blog: Add fake clickable hyperlinks to Excel pivot tables. Video shows the steps. Feb 15, 2023

Debra D Blog: Are you ready to pivot? Yes, Bing Search Chat will change things, but if four people can turn a train, you can pivot your blog, to keep it growing!. Feb 13, 2023

Pivot Table Blog: Troubleshoot the problem for an Excel pivot table not showing all data. Feb 8, 2023

Contextures Blog:Repeat text with Excel REPT function for in-cell charts, table row height & more. Feb 2, 2023

Pivot Table Blog: Show extra subtotals in pivot table, without adding columns. Watch for limitations though!. Jan 25, 2023

Debra D Blog: This Ode to Microsoft Excel, for Robert Burns Day, gives humorous "burns" to other spreadsheets. Jan 25, 2023

Contextures Blog: Can ChatGPT write Excel TEXTJOIN formulas? See my test results. Jan 19, 2023

Combine Text: Combine text and numbers from multiple cells with Excel TEXTJOIN function. 7 examples, basic to advanced Jan 18, 2023

Pivot Table Blog: Pivot table troubleshooting - see quick pop-up message with details. Jan 10, 2023

Play Games in Excel: When your work is done, enjoy playing games in Excel! Do you remember the old hidden games in Excel? Dec 14, 2022

XLOOKUP Function: Basic examples show how to get started with Excel XLOOKUP function, in Excel 365 and Excel 2021. Dec 7, 2022

Pivot Table Blog: How to fix pivot table headings with "(blank)" or remove "Sum of" in headings Dec 7, 2022

Contextures Blog: Use Excel macros to quickly create 12 monthly workbooks, with daily sheets, for the upcoming year. Dec 1, 2022

Contextures Blog: Excel for the holidays - planners, Advent calendars, Christmas trees, personalized messages. Nov 17, 2022

Skip Blanks: Avoid pasting blank cells over existing data with Excel Skip Blanks feature. Nov 9, 2022

Pivot Table Blog: Is it hotter than usual this November? Compare years with pivot table conditional formatting colour scale Nov 9, 2022

Contextures Blog: Have you ever sent Microsoft a smile or frown in Excel? Go to the Help tab, and click Feedback. Nov 3, 2022

Add Sheets Macro: Macro adds new worksheet automatically when file opens at start of month. Nov 1, 2022

UserForm Search: Use this Excel UserForm to search transaction records in a worksheet table. Add new records, or find existing records, and view, edit or delete them. Sept 28, 2022

Contextures Blog: Before you click Remove All button for Excel Subtotal feature, be prepared -- there's no Undo! Sept 22, 2022

Count Blanks: In a pivot table, see how to count blanks in source data cells. Fix problem, get correct count of empty cells. Video, written steps, Excel workbook. Sept 13, 2022

Contextures Blog: How I fixed an Excel error message -- ⚠️ Reference isn't valid. Sept 8, 2022

Contextures Blog: Problems pasting into filtered Excel list? This shortcut might help, or try a workaround. Aug 25, 2022

Contextures Blog: It's football season! New Excel sample data for testing/training - NFL player rosters - 2 teams, 2 years . Aug 11, 2022

Pivot Table Blog: Date filters in Excel pivot tables - try these 3 different types. Aug 3, 2022

Contextures Blog: Video shows how to use wildcards with criteria for a flexible AVERAGEIF formula in Excel . July 28, 2022

Date Grouping: See how to turn off automatic date grouping for Excel Pivot Tables and AutoFilters. July 18, 2022

Contextures Blog: Track your golf scores in Excel, for multiple players & courses . July 14, 2022

Line Breaks: How to add line breaks in Excel cells and formulas. Find and remove line breaks. July 13, 2022

Pivot Table Blog: Quickly check sales progress with % Running Total feature in Excel pivot table - 2 videos show the steps. July 6, 2022

Contextures Blog: How to make country flags in Excel 365, with 1 formula instead of 48672! June 30, 2022

Compare Lists: Compare two Excel lists, to find new items in second list, and add them to first list. June 20, 2022

Pivot Table Blog: Quick and easy steps to make a clustered stacked pivot chart in #Excel. Video and sample file. June 8, 2022

Contextures Blog: How to find product price with Excel VLOOKUP and MATCH, for quantity ordered. June 16, 2022

Status Bar Tips: Use Excel Status Bar info to troubleshoot problems, and get key information. For macros, show custom messages with macro progress updates. June 8, 2022

Debra D Blog: Use bookmarks and shortcut keys for quick navigation in Notepad++ file. June 6, 2022

Contextures Blog: How to count duplicate number sets with Excel formulas, using Excel 365 spill functions. June 2, 2022

Debra D Blog: How to fix mouse double click problem in Microsoft Access, get it working again. May 30, 2022

Contextures Blog: How to show hidden data in Excel chart or Excel sparklines. Change chart setting manually or with macro. May 19, 2022

Basic UserForm - Videos: Step-by-step videos show how to make basic Excel UserForm with text boxes for data entry. May 16, 2022

Pivot Table Blog: Why does pivot table show duplicate numbers? How to fix the problem. May 11, 2022

FILTER Function Reports: See how to create multi-column summary reports, using Excel FILTER Function (Excel 365). May 7, 2022

Contextures Blog: Take a break from your work, and use Excel to stream web radio. May 5, 2022

Debra D Blog: How to fix avi format videos that have audio and black screen, with Video Editor in Microsoft Photos program. Apr 24, 2022

Contextures Blog: See warning if Excel worksheet sheet has hidden rows or columns, and steps show how to fix them. Apr 21, 2022

Compare Cells: How to compare cell values in Excel. Find exact match, or partial match and percentage. Apr 12, 2022

Pivot Table Blog: Help Excel pivot table macros run faster by preventing automatic updates. Apr 6, 2022

Excel Charts: How to show hidden data in Excel chart or Excel sparklines. Change chart setting manually or with macro. Mar 15, 2022

Highlight Weekends: How to highlight weekend data in Excel pivot table with conditional formatting. Fix rule settings to avoid problems. Mar 2, 2022

Excel Printing: How to create an Excel report diagnostic display to check filter settings before printing. Jan 27, 2022

Working Days: How to calculate project dates or upcoming workdays in Excel with WORKDAY function and WORKDAY.INTL function. Jan 17, 2022

What's New in Microsoft Excel