Latest Excel Updates Worth Trying: Canvas, Lists & More
Introduction
Which recent Excel updates are worth trying in your next report? Clearer table setup and easier heading alignment offer small workflow gains. In-cell Lists and Arrays open up new ways to handle multiple values, while Excel Canvas promises a report view built from workbook data.
We’ll test the practical changes in a small request tracker and separate established techniques from preview features. Availability checked on 11 October 2026: Lists and Arrays remain a Beta preview, and Canvas is scheduled for a mid-to-late October rollout.
Why this matters
Most report problems begin before the chart: vague table names, presentation formatting inside source data, or several owners typed as one text string. The latest updates address those friction points in different ways. A name entered during table creation reduces setup work. Center Across Selection helps present a title while preserving the worksheet grid. Lists can make individual items easier to filter, and Canvas could shorten the first pass from data to a report.
Start with the change that solves a real problem in your workbook. If your monthly report already depends on Power Query and PivotTables, a conventional flat source remains the practical choice. If you are exploring a small tracker in a supported Beta build, an in-cell list is a useful experiment. Treat availability, calculation results, and downstream compatibility as three separate checks.
At a glance: which updates are useful?
Excel Canvas: a report view to watch
Excel Canvas is designed to turn workbook data into a report with visualizations, metrics, and insights, then refresh the report as the source changes. You can refine the view with Copilot prompts. The announced rollout covers Excel for Windows and the web for users with access to Copilot in Excel. It is scheduled to begin in mid-October and finish by the end of October 2026. On 11 October, this is an announced rollout; availability in your account may follow later.
Name an Excel table as you create it
A descriptive table name makes formulas easier to read. The September Insider update adds a name field to the Create Table flow for eligible preview users. If that field is not available in your Excel build, create the table as usual and rename it from the Table Design tab. The helpful part is fewer clicks; meaningful table names themselves are not new.
Center a heading without merging cells
Center Across Selection is easier to find from the Merge & Center menu in the preview experience. It centers a title over a selected range while keeping the cells separate, which is handy for a report heading above a table. If your menu does not show the option, use the existing Format Cells alignment controls.
Before moving on, click each cell in the heading range. They should still be separate cells. Avoid Merge & Center on a populated range: merging can discard content in cells other than the upper-left one.
Lists and arrays in cells: interesting, but still a preview
The Lists preview lets one cell hold multiple typed values. Arrays can hold a result with several rows or columns inside a cell. You can filter individual list items and test membership with HAS. Unlike comma-separated text, a list stores its items as separate values. Lists and Arrays are currently a Beta Channel feature for Excel on Windows and Mac.
Before you start
Make a copy of a small workbook. Do not use a live monthly report for the first test.
Use an Excel table with a few request rows and a Summary sheet for the title and total.
For Lists and Arrays, check the supported Beta build first. The September announcement lists Windows Version 2610, Build 20520.20000 or later, and Mac Version 16.114, Build 26092111 or later; staged rollout can still affect what you see.
Record your platform, update channel, version, and build so a teammate can reproduce the result.
Step-by-step solution
Step 1: Copy the workbook and set a baseline
Save a test copy, then note the current number of requests and the total amount. For example, our sample has four requests totaling €4,000. These two checks make it easy to spot an accidental change after you rename a table or add a preview formula.
On Windows, check File > Account > About Excel for your version and channel. On Mac, use Excel > About Microsoft Excel. Menu wording can shift slightly between builds.
Step 2: Give the source table a useful name
On an Input sheet, put RequestID, Department, Owners, Amount, and Status in row 1. Select the range, choose Insert > Table, and confirm that the range includes the headers. If your Create Table dialog has a table-name field, enter tbl_Requests before confirming. Otherwise, create the table first and rename it from Table Design.
Structured references let formulas use table and column labels instead of cell addresses. On Summary, enter this formula in A3, beneath your report heading:
=SUM(tbl_Requests[Amount])The formula adds every numeric value in the Amount column. With the sample records below, the expected result is €4,000. Add a row inside the table and the reference follows the expanded table. If you see an error, check the table name and header spelling. If the total is unexpectedly low, check for amounts stored as text rather than numbers.
Step 3: Make a centered report heading
On a Summary sheet, type Request Review in A1 and leave B1:D1 empty. Select A1:D1. If the preview menu offers Center Across Selection, choose it. If not, open Format Cells and use the alignment option there. Keep the title outside the source table so presentation formatting does not interfere with data columns.
Step 4: Test an in-cell list in the Beta preview
In a supported Beta build, select the Owners cell for the first request and choose Insert > List (or press Ctrl+J if that shortcut is available). Enter Ana and Ben as separate list items, then press Enter. Repeat for one other row. If the list icon or item-aware filter does not appear, stop here—the preview may not have reached your build.
Add a test column named HasAna inside tbl_Requests. For each row, use the following formula to test whether its Owners list contains Ana:
=HAS([@Owners],"Ana")The @ reference points to the current row’s Owners cell. The expected result is TRUE for R-101 and R-103, and FALSE for the other two records. This tests membership, not a substring inside ordinary text. Enter Ana as a separate list item before testing. These are documentation-based expected results; this walkthrough was not run in a Beta Excel session.
The examples use English function names and a comma argument separator. Your Excel language or regional settings may use localized function names or a semicolon. A name error can also mean that HAS is unavailable in your current build; changing punctuation will not enable a missing preview function.
Step 5: Compare before you keep anything
Check that your four request rows and €4,000 total are unchanged. Filter the Owners list for Ana and confirm that only the requests containing Ana appear. Then compare the result with a normal text filter or a separate assignment table. Keep notes on what worked, what was missing, and whether the file opens correctly for another person.
A practical example: requests with more than one owner
Use the fictional teaching data below in your test copy. These are illustrative request records, not reported business results. Enter Amount as numbers and format the column as currency. The Owners entries shown here are labels; create actual list items in the Beta experiment.
RequestID | Department | Owners | Amount (€) | Status |
R-101 | Finance | Ana; Ben | 1200 | Open |
R-102 | Operations | Ben | 800 | Closed |
R-103 | Finance | Ana | 500 | Open |
R-104 | Sales | Cara | 1500 | Open |
The expected total is €4,000. When you add a fifth request for €200 inside the table, the total should become €4,200. If you use the Lists preview, filtering Owners for Ana should return R-101 and R-103. That is the check; the point is not to squeeze every detail into one cell.
For a workbook that feeds Power Query, PivotTables, charts, or another system, keep a separate flat assignment table with one RequestID–Owner pair per row. The current preview has integration gaps: Power Query and PivotTables do not consume array-valued cells as ordinary source data. A compact cell is useful for editing, but your reporting tools still need a data structure they can read reliably.
Keep the request amount only in the request table. In the assignment table, R-101 appears once for Ana and once for Ben. If you repeat its €1,200 amount in both assignment rows and sum that table, you will count the same request twice. Decide whether a report is counting requests, assignments, or allocated cost before choosing a calculation.
For a full dashboard workflow, see Build a Dynamic FIFA World Cup 2026 Dashboard in Excel.
Bonus tips and common mistakes
The new command is missing
Check whether you are on the required Insider or Beta channel and whether your build meets the listed minimum. A release note does not mean every Microsoft 365 account receives the feature on the same day. If you cannot confirm the channel, use the existing table rename or Format Cells route and leave the preview feature out of the workflow.
You merged cells and lost a heading or value
Undo immediately if you can, or restore the test copy. Center Across Selection keeps the cells separate; Merge & Center combines them. They are different actions even though they sit in the same menu.
Lists do not work with a downstream tool
That is a known preview limitation, not necessarily a problem with your formula. PivotTables, charts, data validation, and Power Query have documented gaps with list and array cells. Expand the values into normal rows and columns, or use a flat assignment table, before sending data into those tools.
Copilot creates a report, but the numbers look odd
If Canvas appears in your account, check every metric, chart range, label, filter, and source before sharing the report. A self-refreshing view can still refresh a mistaken calculation. Keep the workbook’s original formulas and source data as the reference.
Final thoughts
The low-risk wins are straightforward: give source tables meaningful names and keep report titles separate from data. Excel Canvas is the October feature to watch if your organization has Copilot access. Lists and Arrays are worth a small Beta experiment, especially when filtering several typed values, but I would keep them away from production data flows until your exact integrations pass a test.
For your next workbook, try the table name and heading layout first. Then, if you have a supported Beta build, test Lists in a copy and compare the result with a flat table. A little checking now beats debugging a surprise in the monthly meeting.
You can also explore Excelized’s executive Excel dashboards for another example of a source-to-report workflow.
Sources and further reading
Build your Excel skills
Want hands-on help with tables and reporting? Explore Excelized’s one-to-one training options, including Excel basics and Excel Tables.
Comments