››Note details

Best NEW Excel Features EVERYONE Needs

BY ckyz6

July 14, 2025•

Public

Private

1434 views

Blog Article Summary: Best New Features in Microsoft Excel

Summarize and highlight the best new features recently added to Microsoft Excel as discussed in the provided content.

Easier Command Access: Right-click anywhere and use the new "Search the Menus" box to quickly find commands (e.g., add validation lists, conditional formatting).
Keyboard Shortcuts Supported: Use Shift+F10 (or Windows+Shift+F10 on some devices) to bring up the menu with keyboard, then search and select commands.
Improved Productivity: No need to search through complex menus to find features.

Better Workbook Navigation: Accessible via View > Navigation.
Overview of All Sheets: Lists all sheets (including hidden ones in light gray); one-click to show/hide/rename/delete sheets.
Content Overview Within Sheets: See and manage ranges, tables, and charts directly from the pane.
Ideal for Large Spreadsheets: Quickly jump between sheets and objects.

Power Query Shortcut: Alt+F12 to open Power Query Editor.
Copy as Values Shortcut: Copy (Ctrl+C), then paste as values with Ctrl+Shift+V, bypassing the need for the 'Paste Special' dialog.
Faster Workflow: More keyboard-friendly, time-saving.

Automate Repetitive Tasks: The new "Automate" tab allows you to record or create scripts using Office Scripts on both desktop and web versions.
Practical Example: Record actions to make a formatted timesheet—actions like bolding, adding dates, borders, etc., are all recorded and repeatable by running the script.
Reusability: Scripts can be stored and run in any workbook.

Easily Debug Formulas: When editing complex or nested formulas, highlight any part to see its intermediate result instantly.
Example: In a nested IF function, seeing which conditions are true/false or what values parts of a formula return.
Better for Troubleshooting: Ideal for working with large, complex formulas.

Direct Import: Use dynamic array functions (like FILTER) as direct source data for Power Query (Data > From Table/Range).
Name/Rename Array: Data imported as arrays can be renamed and manipulated directly in Power Query.
Live Data Connection: Changes to dynamic array sources in the sheet automatically update Power Query outputs upon refresh.
Upcoming Chart Support: Chart data sources linked to dynamic arrays (like FILTER or SORT) will soon auto-expand/shrink to match the array size.

Summary: These new features significantly enhance productivity and flexibility in Excel for users at all levels.
Feedback Request: Viewers are encouraged to comment on their favorite new feature.
Call to Action: Subscribe to stay updated on more helpful Excel tips and features.

End of summary.