9 new features in Microsoft Excel for 2024

Insider and Tech Community Blogs:

📝 Table of contents
0:00 Introduction
0:10 Check Performance in Excel for Windows
1:32 Show Details in PivotTables in Excel for Windows
2:37 Forms to Excel live data sync in Excel for the web
3:22 Export to CSV in Excel for the web
3:49 Drag and drop enhancements for Columns and Rows in Excel for the web
4:34 Autofill enables you to drag data to fill series, copy cells, and split data in Excel fort the web
5:42 Paste options improvements in Excel for the we
6:37 Share link to Sheet Cell in Excel web
7:28 PivotTable for Excel iPad

📺 Top 25 Excel tip and tricks: Top 25 Microsoft Excel Tips and Tricks for 2022 // NEW features, hidden gems and time-saving tips

*Connect with me on Social:

#Excel #MicrosoftExcel #Microsoft

[paulvanobberghen]

The #2 trick was already there for years but not in the ribbon, granted. Just double-click on a value to open a new sheet with relevant data. Only the button in the ribbon is new.

[timoooo]

I’ve been reading about the recent checkboxes but I can’t find them in any of the M365 excel that I have, neither the paid personal, nor the work, nor the university. Why is that?

[SkipMiLuu]

I hope pivot table for Android is coming soon.

[TheBalloonProfessor]

Do you know anything about your second tip for pivottable show details, it breakes the workbook if your using vba/macro?

[martinargimon]

Hi Mike. Thx for your video. Excellent ( once again). Would I know how to check if my MS 365 Version ( in South Africa) has the new ‘check box’ released ( or that I can update ), since that feature is NOT on my software although I have all updates checked and this feature does NOT show up. Thanks

[bobgonynor]

Great video, you didn’t show how amazing flash fill really is. It’s great at extracting data inside other data in a cell. Like a string of numbers inside a cell with numbers and letters. Or a color or size inside a string like “tshirt large green” you could type large the. Flash fill and it finds them all with 99% accuracy.

[Mamonga]

What about Drag & Drop for Excel cells in the Desktop app?

[dave]

column drag with mouse is not part of the insider program version! how did u get that?? i tried to find it on web version and no luck.

[mathew]

Show Details on a pivot table was aleady part of Excel if you double clicked onto a pivottable summarised element - it's disappointing that Excel on the Web appears to be given more love than the windows app

[mrhoneystinger]

Its Neil Pee-rt... not Pert
Your Rush fan card has been permanently revoked

[sergheyzaporojanu]

Guys! Today I noticed something supper odd. And now I wander was it always like this? Here's the issue/bug: in both Excel and GSheets the COUNT(range) and COUNTIF(range, "<>") formulas are counting the cells even if they have formula that outputs "" Blank results!
WHATA HACK IS EVEN THAT?!

[binoythomas]

6.36 pls advise how I can set the paste options description instead of symbols.