Recent Discussions
How to make excel add or remove rows to fit data and prevent spill error?
Hello! My question is: When using the =FILTER formula to copy cell data from one sheet to another, how can I make excel add or remove rows as needed to prevent a spill error? I am using the =FILTER formula to copy cell data from one sheet to another if a checkbox is checked. My formula uses the cells containing the checkbox (column A) as the reference for columns B, C, D, etc. to the right. I did this by selecting the cell that has the formula on the destination sheet, highlighting this cell and those to the right I wanted to transfer, and then control + r. My formula is: =FILTER('Source Sheet'!B5:B13,'Source Sheet'!$A5:$A13=TRUE) (If there is a way to copy an entire row from the source sheet instead of having to control+r to apply the original formula across select cells please also let me know, thank you!). However, I want the sheet to be able to automatically add rows to fit the data if the selected number of rows is greater than what I have left available on the sheet. Currently, if I leave 3 rows for data to fill and I select three checkboxes, this will fill the space with no problem. However, if I select 4+, I get a spill error (as there are not enough empty rows to put the data). Is there any easy way to have excel add rows as needed? Similarly, is there a way for excel to remove rows as needed? I am going to use this sheet to detail all medications being taken by family members (with medication name, concentration, dose, time to take each in their own column as column B, column C, column D, column E). The names will be listed in column A with ~3 rows below each name which will fill when the checkbox on the source sheet is clicked. I want to ideally fit this on one page when printing without major "fit to page" problems that come up during printing. The layout of the sheet will ideally look like this: The goal for the 'destination sheet' is to pull only the selected data I want to use from my master list on the 'source' sheet.' I want to avoid having a big empty space under each family member where they don't take many medications, and to also not have to manually add rows for family members that take a greater number of medications. Please let me know and thank you!
Help with data and visuals
I hope i can explain this right, i have data that shows 3 things: person, start date and end date: now i need excel to take this information and represent it as the following in the month tracker: It would look for the charts and figure out the timeline and add them to a row with the timeframe: example is Booy 15-0ct-25 to 23-oct-25 the char would go to the next one and add his information, I hope someone can help me. I just need it to populate the month tracker, Thanks
Language defaults audit for everything M365
We are struggling to find where and how the wrong language is being used for various parts of the M365 platform. We have Swedish set as default, but still English is used for a number of places which often are only realized as a consequence by a user. For example, in Viva Engage language is set to Swedish, and for the SharePoint as well. But: When a new user logs on VE is in English While the SharePoint web part is in Swedish, the link text have for some time ended with "- Home" (English) instead of as it was when we started 2+ years ago " - Startsida" (Swedish) Then when creating a VE group Event (Teams-meeting) default language is also English Tracking down what and where is making the wrong language being used is hard. I would be very grateful if pointed to a resource that give an as complete as possible overview of everything in M365 that we need to look over for making sure that the correct language is default everywhere it should be.Leveraging SharePoint for Performance Tracking Monitoring Team and Project Progress
SharePoint is more than a document management system; it’s a comprehensive platform that facilitates real-time tracking and collaboration. Here’s why it excels in performance tracking: https://dellenny.com/leveraging-sharepoint-for-performance-tracking-monitoring-team-and-project-progress/
Pivot table
having an Excel workbook with multiple sheets. each contain certain data and a pivot table in each one. recently started having problem that is when I copy a pivot table from an existing data sheet to a new inserted sheet and then changing the source of data to the new sheet and then refresh the pivot table then save and close the file; then when I try to open the file again I got an error and the most recent pivot table get deleted. tried several ways to solve the issue with no avail noting I'm using Microsoft 365 for Mac. appreciate any helpHow to convert from a GoDaddy Office 365 Email Essentials account to a full M365 Business Standard?
I am currently supporting a client who is using a GoDaddy Office 365 Email Essentials account, that they purchased along with their domain registration. They now have need of the full suite of services offered with a Microsoft 365 Business Standard account. However, it's my understanding that the GoDaddy tenants are a specialized product that isn't truly a native Microsoft 365 account. Is this true? If so what would the requirements be to migrate the user's account to a full Microsoft 365 Business Standard account?
Office 365 Business Premium + GoDaddy Hosting
Hi, Does office 365 + godaddy give you office 365 app hosting? I was hoping to have a public sharepoint, delve, and yammer website connected to different subdomains e.g. http://www.mydomain.com, blog.mydomain.com, social.mydomain.com etc. What apps on office 365 are linked to godaddy hosting? Or is it just completely separate hosting that has no link to office 365 apps and just bundles email support? Also what is the discount offered to office 365 subscribers on godaddy? Ideally I would to have Windows unlimited website hosting. Thanks, JebbGoDaddy says i must pay for email 365 even though I have an office 365 subscription
GoDaddy forced me to go to their mail 365 and now they say that I have to pay for their mail 365 system even though I have an office 365 subscription. I am so sick of GoDaddy making their customers pay for things that should be free or included in other software packages. The cost at GoDaddy is about $144 for four domain email accounts!!!! That does not give me any Office 365 features I assume others have faced the same situation. What are my options? JimGoDaddy to Microsoft 365 Email Account Transfer
Hi all, I'm working with a small company that just updated its business name. They want to update their Microsoft 365 licences to the new domain, which is currently registered with GoDaddy. As they weren't ready to change this straight away, some 365 (essential) Email accounts were set up in GoDaddy. Now they are ready to make the 365 update, but the email situation seems really confusing, and the two options seem to be: 1) delete the accounts and set them up again, 2) use GoDaddy to manage the changeover - but the tech support seemed a little vague on this and the timings. Has anyone used the GoDaddy managed change and was it successful? Or would you recommend doing it manually? (Or another option?) Sorry, I know versions of this have been asked before, but I'd really appreciate some up-to-date advice if possible. Thanks very much!transfer Domain godaddy to microsoft 365
,I am having headache to transfer my domain from GoDaddy to Microsoft. I have 3 days and they said that the technician from Microsoft are still working. Andi it's amazing that they have 3 days for remove my domain from their services. Daomain.net was already added to a different Office 365 tenant NETORGFT5470045.onmicrosoft.com which is managed by GoDaddy. To add this domain to this tenant you will need to contact GoDaddy support and have this domain removed from NETORGFT5470045.onmicrosoft.com. Once done you can come back and resume this step. Help
Transferring Office 365 hosted by GoDaddy to Office 365 hosted by Microsoft
How do I transfer my domain from my old Office 365 account hosted by GoDaddy to a new Office 365 hosted by Microsoft? Everytime I try to setup the new Office 365 I get following errormessage: "domain.at" has already been added to another Office 365 mandate (Netorgft123456.onmicrosoft.com) managed by GoDaddy. To add this domain to this tenant, you must contact GoDaddy support and have the domain removed from Netorgft123456.onmicrosoft.com. After this is done, you can come back and continue this step. GoDaddy isnt verry supportive so I try to seek help here :=)Delete cells with 3 consecutive consonants
I submitted a question a little while back asking how to delete cells with exactly 3 consonants. The response I had was a huge help, but now I'm faced with a similar problem: How do I sort words by consecutive consonants? And if that cannot be achieved, how can I instead delete cells from a sheet in which a word has 3 consecutive consonants?
Titre axe secondaire
Bonjour, j’utilise Excel Microsoft 365 sur Mac et je rencontre un problème avec mon graphique de la loi de Pareto (voir capture d’écran jointe). Le graphique combine des colonnes pour le chiffre d’affaires et une courbe pour le pourcentage cumulé. Mon souci est que je n’arrive pas à ajouter un titre à l’axe vertical secondaire (celui de droite, qui affiche les pourcentages). L’option “Titre d’axe secondaire” n’apparaît ni dans le ruban, ni dans les paramètres du graphique, même quand j’active l’axe secondaire. J’ai déjà essayé de passer par les menus contextuels, les options de graphique, et même de modifier le type de graphique combiné, mais sans succès. Pouvez-vous m’aider à afficher ou activer le titre de l’axe secondaire ? Merci d’avance pour votre aide !Taking text from a multi-line cell and making each line its own row.
Hello, I have a sheet with several thousand lines that I pulled from my current system, and all of the data was exported into cells like this: What I would like to do is take each line and make that line its own row in the sheet. For example, the scooter would have its own row, the MWC have its own row, so on and so forth. Is there any way this is possible, or should I be looking to see if there is any other way I can export this data?
error occurred with Powerpoint recording
Hello Community, I have been trying to record a PPT presentation and the moment I stop the recording, this message pops up - "An error occurred with recording. Please try again." I have tried couple of basic troubleshooting, but this won't change. Can anyone please suggest what must be the reason for this error. Thanks
Events
Learn, Connect, and Be Inspired at ESPC25
Join us in Dublin for ESPC25! One of Europe’s largest community conferences, ESPC25 is your opportunity to expand your Microsoft 365 Copilot, Collaborative...
In-Person
Recent Blogs
- You can add Copilot to an existing Teams chat, or start a new group chat directly from a one-on-one conversation with Microsoft 365 Copilot.Oct 24, 2025
- Use Copilot to decipher complex health or finance terms, or find out more information about your company's benefits provider.Oct 23, 2025
