Put multiple values in one cell with lists and arrays in Excel
Throughout Excel's 40-year history, you've only been able to put one value per cell. In this announcement, we're excited to share how that's changing with the release of lists, arrays in cells, and nested arrays, initially to Microsoft Excel for Windows and Mac Beta Channels. Many workbooks already try to pack multiple values into one cell. A project might list "Carlos, Henrietta, Jacob" as three owners, or a Forms survey might return "2:00 PM; 2:30 PM; 3:00 PM" as one response. With lists, you can keep those values in one cell, while also keeping them separate for filtering, calculation and more. Later in this post, we'll explore arrays in cells and nested arrays in more depth. NOTE: These are preview features. Their behavior may change before general release based on your feedback. We don't recommend using them in important workbooks until they're generally available. Lists Lists let you put multiple values into one cell. You can create a list by selecting Insert > List or pressing Ctrl+J, then typing or pasting items separated by commas or semicolons, depending on your regional settings. Selecting the icon in the cell shows the individual values. You can add, remove, or edit list items by double-clicking the cell or pressing F2, just like other values. With lists, you can filter by one or more individual items instead of whole text entries. Referencing a list returns all its values for calculations. For example, =B2 spills those values into separate cells. Arrays in cells Lists are useful on their own, but they're part of a much broader change to Excel. For the first time in Excel, arrays can exist natively in cells as values or as formula results. They can be any size or shape and can even contain other arrays. You can now keep the result of any spilling formula in a single cell by "wrapping" the formula body with braces { }. Since the introduction of dynamic arrays, array results have spilled across cells – for example ={1;2;3}. Wrapping the original array with braces creates a 1x1 array around it, so instead of spilling to multiple cells, the array stays in a single cell. Braces have long been used to describe arrays in Excel and this extends that behavior by allowing multiple layers of braces. This gives you more flexibility when building spreadsheets. Instead of leaving room for a formula to spill, you can keep the result in one cell. Arrays inside arrays, or nested arrays Arrays can now also "nest" inside other arrays. For example: ={{1,2,3};{4,5,6}} Previously, a formula that produced an array of arrays would return a truncated result or #CALC! error. Now, supported formulas return the complete nested result. In the example below, you can see how TEXTSPLIT behaves with and without nested arrays. Without nested arrays, Excel only returns the first item for each row. With nested arrays, the result spills, one array per row. The arrays in each row can then be used in further calculations. Four new functions: FLATTEN, HAS, HASANY, HASALL To help you work with arrays more easily, we've added four functions. FLATTEN(array, [pad_value], [levels]) simplifies nested arrays by removing one or more levels of nesting. Continuing from the prior example, FLATTEN lets you simplify the nested array output, spilling the individual results into the grid. We used an empty string ("") for pad_value so rows with fewer items show blanks in the remaining columns. Three HAS functions check whether values are in an array: HAS(array, value) returns TRUE if value appears anywhere in array, and FALSE otherwise. HASANY(array, values) returns TRUE if any of the values appear anywhere in array, and FALSE otherwise. HASALL(array, values) returns TRUE if all of the values appear anywhere in array, and FALSE otherwise. Do more with spreadsheets using arrays in cells and nested arrays Arrays in cells open up spreadsheet designs that weren't practical before. The run tracker below captures split times (how long it takes to run each kilometer) in a table with one run per row. The number of splits depends on the length of the run. Stats for each run are calculated right in the same table. For more examples, I recommend looking to your favorite Excel communities on LinkedIn, YouTube, Reddit, or elsewhere. Enabling nested array calculations in a workbook Compatibility Version 3 will be released alongside arrays in cells and is required for most calculations involving nested arrays. You can set Compatibility Version for each workbook in by selecting Formula > Calculation Options. See compatibility versions for more information. Some existing formulas return different results in Compatibility Version 3. If your workbook doesn't behave as expected, you can keep it set to Compatibility Version 1 or 2. Known limitations As this feature rolls out to Beta Channel, the following limitations apply: Conditional formatting doesn't inspect array contents unless you use a formula Data validation can't use a list or array as dropdown items Charts don't expand an array into data points PivotTables don't read array values as source data Power Query doesn't load or emit array-valued columns Find & Replace can't replace list/array items Availability These improvements are rolling out to Beta Channel users running: Windows: Version 2610 (Build 20520.20000) or later Mac: Version 16.114 (Build 26092111) or later Features covered on this blog roll out over time to enable us to monitor quality and performance, so some preview features may not be available to you right away. Also note that features may be paused, adjusted, or removed as part of that process. Feedback Click Help > Feedback in Excel to tell us what you think.Partner Blog | From Copilot adoption to agent-powered growth
A successful Copilot trial opens the door to a much bigger customer conversation and a bigger role for partners. Once users experience the value of AI in their daily work, partners can guide customers to extend that value across teams, workflows, and business processes while maintaining the security, governance, and cost controls needed to scale. In my recent post, From AI curiosity to Copilot adoption in 30 Days, I introduced how Cloud Solution Provider (CSP) partners can use a guided, 25-user trial to bring Microsoft 365 Copilot Business to small and medium-sized business (SMB) customers. That initial experience creates momentum, but sustaining it requires a structured approach to adoption, governance, and expansion. The opportunity is growing with the new Copilot, which brings Home, Code, and Autopilot together in one connected experience. Combined with a commercial model that supports subscriptions and usage-based billing, these advances create new ways for customers to move from AI assistance to delegated work and agent-powered business processes. For partners, this expands opportunities across the customer lifecycle, from guiding adoption and securing environments to developing agents, managing AI consumption, and delivering ongoing services. The key is connecting these capabilities into a repeatable practice that evolves alongside customer needs. Build on the momentum of Copilot in 30 The first 30 days give customers a practical foundation for working with AI. Through Copilot in 30, users explore how Microsoft 365 Copilot Business can improve everyday productivity across Outlook, Teams, Word, Excel, and PowerPoint before progressing to agents and more advanced scenarios. The Copilot Success Planner gives partners a structured way to guide this experience. It creates personalized learning plans for the 25 trial users, along with a roadmap for the customer sponsor. The guided journey builds skills progressively. If the sponsor enables Copilot Cowork, Weeks 3 and 4 add Cowork prompts that introduce the possibilities of delegated work. At the end of the trial, partners can use the sponsor's Day 30 value readout to identify where Copilot delivered results, which users and teams are ready to expand, and where additional capabilities could create business value. That conversation now has a broader destination. With the new Copilot, customers can move through connected experiences: Home brings Chat, Copilot Cowork, and Office together, so users can ask questions, create content, and delegate more complex work. Code extends AI-powered solution development, so users can turn natural-language ideas into apps, dashboards, automations, and workflows. Autopilot introduces a persistent, proactive personal agent designed to keep work moving within organizational permissions. Home and Code are rolling out through the Frontier program, and Autopilot is in private preview. They expand what customers can explore as their AI maturity grows, building on the foundation of everyday Copilot adoption. For partners, the next step is to turn early success into a longer-term customer roadmap. The Microsoft 365 Copilot + Agents SMB Guided Experience (download kit) provides a ready-to-deliver, 90-minute engagement to reinforce value, explore new scenarios, and guide the transition toward broader adoption. Continue reading here
Talk to a live agent at Microsoft 365
Firstly, I don't know if this is the correct place to ask, if not, I apologise, and would be greratful if I could be directed to the correct medium. So..... *** I am writing this on behalf of someone else *** His account has been locked after he had been hacked and infected with a virus, and Microsoft will not unlock it. However, they have decided (today) to take his money for his 365 subscription, that he can't use, and doesn't want. When looking for a way to cancel it, the answer is log-in to his account and cancel it himself. BUT, he can't log in because the account is locked. He has tried looking for a phone number to speak to someone, but cannot find any. He has tried looking for a Live Chat, but, (if it exists) it is only available after he logs in. He just wants to cancel the subscription, and get a refund. Can someone please give me a contact number - preferably in the UK, but any English speaking representitive, in any countrty will do. Thanks,SharePoint HTML Pages with Copilot: Create, Upload, Edit and Publish
Hi everyone, SharePoint is adding support for HTML pages (Message Center ID: MC1479517). You can create an HTML page with Copilot in SharePoint or upload HTML from another source. Once the page is stored in the Site Pages library, you can render it as a page, edit it, publish it and share it alongside your existing ASPX pages. I recorded a full walkthrough with live demos, and I'd love to hear how you plan to use it. What's new - Create an HTML page from + New > HTML page on a SharePoint site - Create one from the floating Copilot button on a SharePoint site - Create one from the Publish landing page via + Create > HTML page - Describe the page in a prompt and attach files for additional context - Upload an existing .html file, or HTML pages and folders, from the Site Pages library - Edit text directly on the page, or use the Copilot chat pane for broader content and design changes Good to know - Publishing an HTML page does not grant new permissions. Existing SharePoint permissions decide who can see it. - Creating or editing a page with Copilot requires a Microsoft 365 Copilot license. Uploading, editing directly, publishing and viewing do not. - HTML pages are enabled by default. Site owners can control this with the "Allow HTML files" setting in the Site Pages library (File types). - The site-scoped Agent creation entry point is being removed from the + New menu on site pages. You can still create agents from the command bar of a document library or list, and from the context menu of selected files. Rollout - Public Preview: early October 2026 - General Availability (Worldwide): mid-November to late December 2026 No admin action is required before rollout. You may want to inform your SharePoint authors, update your internal page authoring guidance and review your Copilot license assignments. Resources - Official guide: https://un5m2082uu7vwemkc66pmt09k0.subtlesoundimmersion.net/en-us/sharepoint/create-edit-publish-html-pages - More Microsoft 365 and Copilot content: https://un5hgz1xtkwm0.subtlesoundimmersion.net/@delucagiulian Questions for the community - Will you create HTML pages with Copilot, or upload your own HTML? - Which use cases are you most excited about: landing pages, dashboards, team hubs or something else? Looking forward to your thoughts! Giuliano
Talk to a live agent at Microsoft
Firstly, I don't know if this is the correct place to ask, if not, I apologise, and would be greratful if I could be directed to the correct medium. So..... *** I am writing this on behalf of someone else *** His account has been locked after he had been hacked and infected with a virus, and Microsoft will not unlock it. However, they have decided (today) to take his money for his 365 subscription, that he can't use, and doesn't want. When looking for a way to cancel it, the answer is log-in to his account and cancel it himself. BUT, he can't log in because the account is locked. He has tried looking for a phone number to speak to someone, but cannot find any. He has tried looking for a Live Chat, but, (if it exists) it is only available after he logs in. He just wants to cancel the subscription, and get a refund. Can someone please give me a contact number - preferably in the UK, but any English speaking representitive, in any countrty will do. Thanks,Partner Blog | Make each Microsoft 365 Business Premium opportunity a security conversation
Small and medium-sized businesses (SMBs) want to put cloud and AI to work while protecting their people, data, and operations. Cybersecurity Awareness Month brings those priorities into focus each October, but building a secure foundation for productive, AI-ready work is a year-round business need. For Microsoft partners, that makes each Microsoft 365 Business Premium opportunity a security conversation and a path to recurring managed services. Lead with the outcomes customers need: adopt AI with confidence, strengthen protection against advanced cyberattacks, and secure sensitive data while addressing compliance requirements. Microsoft 365 Business Premium brings productivity and foundational security together. Microsoft Defender Suite for Business Premium and Microsoft Purview Suite for Business Premium extend that foundation with advanced threat protection, data security, and compliance capabilities. Together, they give you a connected Microsoft platform to assess, deploy, manage, and expand as customer needs evolve. The opportunity continues well after the initial sale. By guiding adoption, maintaining security posture, and strengthening governance, you can build repeatable managed security services that deepen customer relationships and create opportunities for recurring revenue. Security is the foundation for productive, AI-ready work Security is now a priority across the partner ecosystem and a prerequisite for nearly every customer initiative. Secure identities, protected data, threat protection, and clear governance create the foundation for productive work today and for governed AI adoption over time. That’s the thinking behind the FY27 SMB sales plays, including the “Run your business securely” security sales play. Rather than leading with a product list, start with the business outcome the customer is trying to achieve and the risk that could get in the way. The FY27 SMB partner resources provide conversation guides, pitch materials, and discovery questions you can use to turn that framing into a business case. The FY27 SMB Channel Partner Playbook extends that guidance across customer conversations, readiness, and go-to-market execution. This secure foundation also matters as customers move from isolated AI use to repeatable, governed ways of working, a core part of Frontier Transformation. For SMBs with lean IT teams, or who rely on their Managed Service Provider (MSP), an integrated approach can simplify the environment while improving visibility across identity, endpoints, data, and compliance. Partners can guide that progression by keeping security, productivity, and AI readiness connected throughout the customer relationship. Continue reading here
I need to speak to a person at Microsoft
Firstly, I don't know if this is the correct place to ask, if not, I apologise, and would be greratful if I could be directed to the correct medium. So..... *** I am writing this on behalf of someone else *** His account has been locked after he had been hacked and infected with a virus, and Microsoft will not unlock it. However, they have decided (today) to take his money for his 365 subscription, that he can't use, and doesn't want. When looking for a way to cancel it, the answer is log-in to his account and cancel it himself. BUT, he can't log in because the account is locked. He has tried looking for a phone number to speak to someone, but cannot find any. He has tried looking for a Live Chat, but, (if it exists) it is only available after he logs in. He just wants to cancel the subscription, and get a refund. Can someone please give me a contact number - preferably in the UK, but any English speaking representitive, in any countrty will do. Thanks,
Trying to get support in reseting Authenticator MFA
Hello! We are locked out of our tenant's admin center as our authenticator installed device has been reset by mistake. I contacted our call MS service phone number (211 18 13 880) in Greece, but the AI bot is unable to record the case as it cannot vocally identify the admin user account and domain of our tenant, finally it terminates the call. There is no direct contact email or phone to human support from the data protection team. How are we supposed to handle this case further? .
What should I do if someone has hacked my account and I can't log in?
Hello, I would like to ask a question. Someone hacked my Microsoft account and I don't know what to do, which is why I am writing here. Do you think anyone would be able to help me? Please, I am already desperate and don't know what to do. Thank you for your reply.
