Welcome to the April 2023 update. This month, in Excel for web, Chart Task Pane is now generally available along with hyperlinks in comments and performance improvements related to conditional formatting (CF) - CF performance improvements also available in Excel for Windows and Mac. For Insiders, the Quick Access Toolbar is now shown by default in Excel for Windows.
A couple new sets of Excel templates, Retirement and FIRE estimators and Essential Tips for conditional formatting, are now available for everyone to try. Additionally, check out this Introduction to the Data Science Process – watch the video >
Excel for web:
- Chart Task Pane #FIA
- Hyperlink in Comments
- Speed Up Filtering when Cells contain Unique or Duplicate Conditional Formatting Rules
- Reducing Unwanted Fragmenting of Conditional Formatting Rules
Excel for Windows:
- Quick Access Toolbar (Insiders) #FIA
- Reducing Unwanted Fragmenting of Conditional Formatting Rules (Current Channel)
Excel for Mac:
- Reducing Unwanted Fragmenting of Conditional Formatting Rules
Excel for web
| #FIA! |
Chart Task Pane
The Chart Task Pane now supports data editing such as modifying the chart's data range, removing a series, or choosing which axis to plot your data on. You can find these options in the new "Data" tab alongside the existing "Format" tab. This feature is currently rolling out to Production.
Hyperlinks in Comments
Add hyperlinks in comments to reference a source like a spreadsheet, document, or webpage in conversation with others collaborating with you.
Speed Up Filtering when Cells contain Unique or Duplicate Conditional Formatting Rules
Speed up filtering when cells contain Unique or Duplicate Conditional Formatting rules, by optimizing the underlying comparison algorithm.
Reducing Unwanted Fragmenting of Conditional Formatting Rules
When a workbook is opened this feature will merge those fragmented conditional formatting rules that are identical, within a contiguous range of cells, and with unchanged priority ordering. It excludes rules whose evaluation relies on a selection range like Above or Below average, Unique or Duplicate, Gradients, etc., and rules in PivotTables.
Excel for Windows
| #FIA! |
Quick Access Toolbar (Insiders)
With this newest update, the Quick Access Toolbar is now shown by default and includes the Undo, Redo, and Save commands, and the AutoSave has found its rightful place back on the title bar. You can quickly customize the QAT to keep only the commands you need. Read more >
Customizable Quick Access Toolbar
Reducing Unwanted Fragmenting of Conditional Formatting Rules (Current Channel)
When a workbook is opened this feature will merge those fragmented conditional formatting rules that are identical, within a contiguous range of cells, and with unchanged priority ordering. It excludes rules whose evaluation relies on a selection range like Above or Below average, Unique or Duplicate, Gradients, etc., and rules in PivotTables.
Excel for Mac
Reducing Unwanted Fragmenting of Conditional Formatting Rules
When a workbook is opened this feature will merge those fragmented conditional formatting rules that are identical, within a contiguous range of cells, and with unchanged priority ordering. It excludes rules whose evaluation relies on a selection range like Above or Below average, Unique or Duplicate, Gradients, etc., and rules in PivotTables.
Check if a specific feature is in your version of ExcelClick here to open in a new browser tab
|
Your feedback helps shape the future of Excel. Please let us know how you like a particular feature and what we can improve upon—send us a smile or frown. You can also submit new ideas or vote for other ideas via Microsoft Feedback.
Subscribe to our Excel Blog and the Insiders Blog to get the latest updates. Stay connected with us and other Excel fans around the world – join our Excel Community and follow us on Twitter.
