Recent Discussions
Conditional field code
Hi, I'm trying to create some conditional code as seen in the screenshot below: But when I update the field it just shows a field code saying STYLEREF I need it to insert the paragraph number from the referenced paragraph if it's above 0 and if it's zero I need it to not insert anything. Where it says "Error!*", I tried removing that and inserting "0" but this had no effect. I was wondering if someone could help me out? Thanks in advance.
Stumped on auto populate staying in a combo box
This is embarrassing. I’ve been building databases since 1999 and now I’m stumped I have an MS Access database with a combo box that is used to select specific records. These records have two particular fields. A primary key named “Track” and a value associated with it called FTitle. Track is a numeric field and FTitle is text. FTitle shows the job title. I had this working beautifully on a database for six years. Go into the combo box, start typing in the FTitle and it would auto populate with an FTitle name. I've checked everything. Auto expand and everything else Two things are happening here. I cannot get an autopopulate combo box to work. It works when I make it. Then when I reopen the form it stops working. I tried to add options to the existing front end which autopopualted perfectly. It seems that when I added a subform to the form the combo box auto populate on stopped working. Any advice??How can I find merged cells in a large spreadsheet?
The file has around 80,000 cells. When I tried a new sort, it said "To do this, all the merged cells need to be the same size". I use merged cells fairly often, but I can't remember where I did that in this file (it's even possible there are none). So I followed the Help instructions for 'Find merged cells' but at the final 'Find All' step, I got "We can't find what you were looking for. Click Options for more ways to search." Any suggestions/solutions?
Allow removal of "Copilot Suggestions" from right-click menu
I have been using Excel for decades and CONSTANTLY use the right-click menu for quick access to basic functions (e.g., "Insert"). Ever since "Copilot Suggestions" was added to the drop-down list, it always throws me off due to its placement. I have Microsoft 365 on Windows 11 Pro. I have searched for ways to remove this from appearing there and the result said "go to File > Options > Copilot and uncheck the 'Enable Copilot' box". However, when I attempt to do that, there is NO "Copilot" option available! PLEASE allow removal of "Copilot Suggestions" from the right-click menu OR at least the option to move it to the bottom (so it isn't in the way of things used ALL the time). I realize that Copilot is a great resource for many users, but I am confident in my Excel skills and in my ability to research/learn new skills the "old school" way, so I have little use for this feature now and would prefer to hide it.
How to create form to enter data into spreadsheet?
I'm rusty after 20+ years regular working in Excel but not so much after being retired for 9 yrs. Need to create form to enter data into spreadsheet. Initially inputting data myself but eventually allowing input from multiple users. Need help to get started.Welcome to the Excel Community
The Excel Community is a place we've built for all of you. You can learn more about how to do something with Excel, discuss your work, and connect with experts that build and use the product. With over half a billion Excel customers, we want to engage with you in fundamentally different ways and the community is a starting point for that. Our community helps answer your product questions with responses from other knowledgeable community members. We love hearing feedback and feature requests from you which helps us build the best version of Excel ever. If you have found an outage or a bug please post at our Answers forum. We look forward to getting to know you! Sangeeta Mudnal & Olaf Hubel on behalf of the Excel Team
Problem with footnotes
When I add a footnote in (all) Word files, it automatically adds an Enter key below the footnote. When I close Word and reopen it, it duplicates that Enter key. Microsoft Help has already been contacted; he performed updates and also checked options and paragraphs options, but found nothing. He referred me here because it appears to be an underlying problem. How can I solve this?
Identifying the highest values from multiple sources
I'm working on putting together seasonal statistics from a sporting league (Cricket). One of the stats I need is each player's highest individual score from the season, but with more than 300 players in the League, manually finding each player's top score during the season is not practical. So far I have used "sortby" to produce an alphabetical list of each player and their individual scores from the season in descending order. I have a small example below of where I am. Player Scores Not Out Player A 66 0 Player A 47 0 Player A 45 0 Player A 42 0 Player A 33 0 Player A 18 0 Player A 14 0 Player A 11 0 Player A 5 0 Player A 4 0 Player A 4 0 Player A 2 0 Player A 1 0 Player A 0 0 Player B 7 0 Player B 4 0 Player B 3 0 Player B 2 0 Player B 2 1 Player B 1 0 Player B 0 0 Player B 0 0 Player B 0 0 Player B 0 1 Player C 105 1 Player C 50 0 Player C 31 0 Player C 23 0 Player D 97 0 Player D 94 0 Player D 69 0 Player D 69 0 Player D 20 0 Player D 15 0 Player D 13 0 Player D 11 0 Player D 10 0 Player D 7 0 Player D 2 0 Player D 0 0 Player D 0 0 Now I just want extract each player's highest score from the season, so that I end up with just the top score for each player. What I am trying to end up with from the above array would look like the following Player Scores Not Out Player Scores Not Out Player A 66 0 Player A 5 0 Player C 105 1 Player D 97 0 I've tried the 'Unique' Formula, but no luck.
Extract Functions from a Formula
Hello, I often go to the Excel BI Challenges on linked in. I have started my own spreadsheet that I use as a reference. Anyway, what I do is take one of the formulas that has been given in the comments of the challenge and then try to break it down and learn from it. I think the best way would be to give an example. In challenge number 379, my contents page looks like this for this challenge: The formula I used is given by Bo Rydobon who often gives great formulas as well as a host of others. Underneath the formula, you can see that I manually type in all of the functions used in the formula and then I have a LAMBDA formula that takes that list and sorts it ( =LAMBDA(A,UPPER(TEXTJOIN(", ",,SORT(TEXTSPLIT(A,,", "))))) ) Your mission, if you choose to accept it is to figure out a formula that will extract all the functions from the formula ideally sorting them with the assumption that all variables are lower case and only the fucntion names are in upper case. Here is the formula again that is not a picture: =MAP(A6:A14,LAMBDA(a,LET(n,--TEXTSPLIT(a,,","),TEXTJOIN(", ",,MAP(DROP(n,-1),SEQUENCE(ROWS(n)-1),LAMBDA(m,i,REPT(m,AND(m<DROP(n,i))))))))) Thanks in advance. PS Bonus Question. This formula uses an AND function; but only gives one argument. Is this because the array contains more than one value? What reasons would use the AND or OR and only use one argurment. Thanks again.Power Automate not pulling all form answers
I have a flow that triggers fine using the "When a new response is submitted" but the "Get response details" is only returning a few of the answers submitted. I can see the full submission the the back end of forms but Power Automate is not pulling a lot of the submitted answers. It has worked fine for 50 times, the automation is long and complex so if possible id like to stay away from deleting and restoring the trigger and get response details...Put a specific word in a cell based on the word in another cell
Hey everyone, I need help automating the categorisation of my bank statement in excel. I do not have microsoft 365. I want excel to look for specific words from my transactions eg Woolworths or McDonalds and then based on that, put another word into the categories cell. For Woolworths I want it to populate groceries, for McDonalds I want it to populate Eating Out. Etc. I would really appreciate the help and in the most basic way possible. I only use basic formulas, so array formulas are quite foreign to me. I have tried googling and nothing seems to work quite right. Happy to move columns around, but would prefer to keep Date, Amount & Description next to each other as that is the order from my bank statement download. I also don't need the Merchant / Category section in notes, but previous attempts led me to adding them. Thanks
Microsoft 365 error 7q6ch , can't login to my microsoft account
Microsoft 365 for business account, getting a microsoft popup box everytime I open office to login. I enter my email address and the next screen is always an error "7q6ch" . I can login to office.com no problem. This error will not go away no matter what I do and here's what've done- removed all microsoft credentials, logged out of microsoft account, removed all accounts in settings, signed out of office, rand scannow, ran the fixes to delete the folders in app data, online repair, quick repair, ran the cmd promp and powershell fix, made a new profile, I uninstalled and reinstalled office, keep getting this popup. The only option I'm seeing is to wipe my computer which I really don't want to do. It's a windows 11 pro laptop I downloaded the office setup file from my office account and it's up to date. I believe this stems from microsoft making me enter an account in order to setup my computer and since it doesn't allow work email addresses I had to use my personal account which then logs in to app automatically and the computer get confused. I need help please, any suggestion or fixes are appreciated, thanksAnnouncing Office 365 for IT Pros (2026 Edition)
Office 365 for IT Pros (2026 edition), the 12th in an eBook series going back to May 2015, is now available. Covering all the essential aspects of Microsoft 365 tenant management from Entra ID to Exchange Online, SharePoint Online, OneDrive for Business, Teams, data lifecycle management, information protection, and more, Office 365 for IT Pros is an indispensable companion for tenant administrators who want to understand how Microsoft 365 really works. https://office365itpros.com/2025/07/01/office-365-for-it-pros-2026-edition/Why are documents now displaying tiny cells and none of my cell text is visible.
Opened this application today to find this. The view is damaged or corrupted so that there are hundreds or thousands of cells visible in the viewport at 100% view scale. Zooming in does nothing to improve this. Zooming out to 10% then appears to show some of the text very small in the top left of the viewport, until zoomed in again at which point the text disappears once more. What is visible is very clear in the screenshots attached to this post. We have attempted an online repair of microsoft 365. this has done nothing. All existing documents persist in showing this. All new documents persist in showing this. We do not know what windows updates have been done. Nothing has been done by us. We do not know if any changes to drivers has occurred. Nothing has been done by us. We are looking for advice or knowledge from any user/s who have seen this specific issue before.Hightlight date cells based on expiry
Hi, I have inherited a spreadsheet of employees who have been on various courses based on their roles, the courses either have a 12 month, 2 year or 3 year expiry date, they are ordered in their relevant columns. the dates are past dates and i need to add a formula so i can see when each person is 60 days out from needing to renew their course (amber) is over the due date (red) and the rest can be green, this gives me enough time to book the ambers in with pleny of notice and shows the current expired courses to prioritise. i think i can use the TODAY() formula but as each date field is a historic date i need to work off each individual field to give that persons due dates as they have gone on courses at different dates from each other. currently it is a nightmare tyring to keep track and i need a simpler visual que. any help would be great. thank you.
Importing CSV file properly
Hey, I'm having issues importing a CSV file properly. There are three columns of data, two columns as dates and one as a measurement. I have done all the steps to import the CSV data. I've saved the data as a CSV file, then gone to Data > From Text/CSV > Chosen the CSV file > Put the delimiter as "comma" as the data is separated by commas, and it all still appears in one column. So then, I tried a different way. I tried Highlighting the data > Text to columns > Put the delimiter as "comma." Now, this worked to put the data in to columns, but then I needed to change the date format. The data originally displays the dates as YYYYMMDD, with no forward slashes or points between the dates. I tried to change the date via the "Number" function in the "Home" tab, but it won't change the dates and they all appear as hashtags. I tried to get help from a Uni adviser, but they were unable to give me a solution. I'm really stuck now as I have looked on forums, microsoft pages, YT videos, everything. I have the most recent version of Excel, have checked my settings, everything. I would really appreciate any help.Calculator
I'm trying to find how I can use each cell as a calculator essentially. I'm making a financial spreadsheet and instead of using a calculator to add the totals from a website and then putting that new number in the cell, I would like to type numbers into a cell and it auto calculates the sum, like a calculator. I'm aware of the autosum feature for columns and rows, but that's not what this is. I want a specific cell to add the new numbers I'm typing in to the previous number. Does that make sense?
Events
Agent 365--generally available May 1, 2026--is a control plane that empowers IT admins, Security Operations analysts, Identity and Network Security admins, and Data Security & Compliance admins to ob...
Online
Recent Blogs
- Frontier Transformation is about fundamentally changing how organizations operate – embedding AI into everyday workflows to accelerate decisions, improve outcomes, and drive measurable business impac...May 01, 2026
- 14 MIN READLearn which capabilities are generally available for observability, governance, and security of agents with Agent 365—the control plane for agents.May 01, 2026
