MO 365 Excel - Difficulty Changing a Date format
I am using MO 365 - apps for Business, currently received an Excel Spreadsheet and am attempting to change date format in Excel and have tried all the usual methods however the dates remain unchanged. I need to change the date from month /day/year as 1/31/2025 to Year/Month/Day 2025/1/31 Any Suggestions? Thanks CJ
Creating weekly calendar template that has overlapping positions
Hi, I have a software for individuals to sign up for shifts, but it is visually hard to see where there are open areas that need to be filled. I need help creating a calendar from this software download that I can update each week. It would have to be much like an hourly scheduler view to easily see when someone is coming on and off shift. But also laid out from Sun-Saturday. There is 3-4 "slots" for each day. It would be great if they could be color coded as well. Slot 1 needs to be anyone that is "AEMT" in the position column, Slot 2 can be anyone listed as "EMT" or "EMR" (caveat to this would be that slot 2 could also be AEMT if there is already an AEMT in slot 1 for the same time slot. Slot 3 is for driver or ride along (or the other 3 positions if there is one listed in the other slots), and possibly 4th slot would just be overflow in case there were 4 people signed up which does not happen very often. Is there anyone who can help me with designing this? Below is what the software generates when converting to excel
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.
Excel 365 Sheet Views are not working
I have 7 different Sheet views in a shared document, they were working fine until about a month ago. Since then I have tried everything, I deleted them, created them again and they don't work. When I create them they look fine but once my collaborators enter to work on the spreadsheet all the views start showing the default view. The sheet has the black border and the eye in the tab. How can I solve this
Pivot Table
Hello, I am currently working on several dashboards that include multiple Pivot Tables Is there a way to filter data using the Filters field in Pivot Table design with conditions such as "greater than", "less than", etc..? At the moment, I have to manually select each value I want to keep, which is quite frustrating when the selection is huge It would be very helpful to have condition filtering available in this area Could you consider adding this feature in a future update ? Thanks in advance,
Insert a row
Hello, I want to insert a row in Excel to shift the existing data downward, but an error message prevents me from doing so, stating that non-empty cells would be pushed off the edge of the worksheet. Could you please tell me how to insert this row without deleting my existing data? thank you !Office Scripts
i have a business microsoft office account and am signed in with it. when i try running a script in excel i keep getting the error saying it requires a work or school account. my microsoft account says the following: your work or school account belongs to your home organisation. what do i need to do to get scripts working.
