21 New Excel Features Released in 2021

Bottom line: Learn about new features that Microsoft released for the Windows, Mac, web, and mobile versions of Excel in 2021.

Skill level: Beginner

Video

Watch on YouTube & Subscribe to our Channel

I Love Excel Updates!

Over the past few years, Microsoft has released a ton of updates to Excel. And 2021 was no exception!

The Windows, Mac, web, and mobile versions of Excel all received cool new updates that will help us get our jobs done faster. This includes everything from new keyboard shortcuts to advanced (Lambda) functions for complex array formulas.

I absolutely love all the new additions to Excel. There were so many updates last year, that I had a difficult time narrowing down the list to just 21 features.

These are the features that stood out the most to me, but feel free to leave a comment below if there are any of your favorites that I missed.

21 New Excel Features from 2021

  1. Unhide Multiple Sheets: Microsoft Announcement
  2. Navigation Pane: Microsoft Announcement
  3. Resize Conditional Formatting Box: Microsoft Announcement
  4. Show Changes: Excel Campus YouTube video & post on Show Changes | Microsoft Announcement
  5. LAMBDA Helper Functions: Microsoft Announcement
  6. Wolfram Data Types: Microsoft Announcement
  7. Visual Update & QAT Button Names: Microsoft Announcement
  8. Accessibility Ribbon: Microsoft Announcement
  9. Excel Data Type APIs: Bill Jelen's YouTube video on Data Type APIs | Microsoft Announcement
  10. Horizontal Scroll Shortcut: Excel Campus YouTube video on 7 Excel Tips
  11. Smooth Scrolling: Excel Campus YouTube video on Smooth Scrolling| Microsoft Announcement
  12. Excel Full Screen Mode
  13. Searchable Dropdown Lists: Excel Campus List Search Add-in | Microsoft Announcement
  14. Power Query Pane: Microsoft Announcement
  15. Text to Columns: Microsoft Announcement
  16. Keyboard Shortcuts for Web: Microsoft Announcement
  17. Office Scripts: Microsoft Announcement
  18. Office Scripts Buttons: Microsoft Announcement
  19. Name Manager & Find All for Mac: Microsoft Announcement Name Manager | Find All
  20. Format Painter for Tablets: Microsoft Announcement
  21. Feedback Portal: Microsoft Announcement

Availability

In the video I tried to mention the various endpoints (Windows, Mac, web, mobile) that the features are available on. I did not mention the specific Excel versions or Microsoft 365 channels because that will change as the features roll out to production. You can see the current availability of each feature in the articles linked above.

Show Your Appreciation

As a Microsoft MVP, I have the honor of being able to connect with Excel team at Microsoft, and I get to see a glimpse of all the hard work that goes into making these updates happen.

Some of these “seemingly simple” updates can be challenging to implement when modifying a code base that has existed for 35+ years. So I'm very grateful to see so many new features in such a short amount of time.

As I mention at the end of the video, most of the authors of the announcement articles linked above are the product managers (Microsoft employees) that help bring these features to life. Many of them are active on LinkedIn, Twitter, and other social platforms.

If you love one of the new features, take a minute to connect with them and share your feedback.

And feel free to leave a comment below with any updates I missed or feedback on the features you like the most. Thank you! 🙂

  • The new text-to-columns is certainly useful, but Excel needs the equivalent of Google Sheets’ SPLIT function, which enables text-to-columns outcomes formulaically.

  • Hey There,
    Well with all good things, there is an end. For me it’s now. I have retired and have started doing many things that have had to be on the back burner for sooo long. One thing that I will not be using as much is my Excel tables. I have been able to find millions in saving for my company in a large part because of the tips you gave. I thank you very much for all your help and guidance. You keep it up there are many like me that need you help.

  • Sir, 7/1/2022.
    I have observed that you have taken lot of efforts.
    I must salute for the same.
    Hoping to receive more and more solutions in Excel in near future too.
    I remain.

    Kanhaiyalal Newaskar.

  • Search
    Generic filters
    Exact matches only

    JOIN US & LEARN EXCEL

    Learn 10 great Excel techniques that will wow your boss and make your co-workers say, "how did you do that??"
    Plus weekly updates to help you learn Excel.

    Download the eBook

    Excel Shortcuts List

    keyboard shortcuts list banner

    Learn over 270 Excel keyboard & mouse shortcuts for Windows & Mac.

    Excel Shortcuts List

    Join Our Weekly Newsletter

    The Excel Pro Tips Newsletter is packed with tips & techniques to help you master Excel.

    Join Our Free Newsletter

    About Me

    Jon Acampora Profile

    Hello and welcome! My name is Jon Acampora and I'm here to help you learn Excel.

    This blog is updated frequently with Excel and VBA tutorials & tools to help improve your Excel skills and save time with your everyday tasks. Subscribe above to stay updated. More about me...

    MVP_Horizontal_BlueOnly

    Free Excel Training Webinar Modern Power Tools

    >