427 questions with Microsoft 365 and Office | Excel | For education | MacOS tags
Data validation list values on excel worksheet for Mac OS not updating automatically
In an Excel worksheet for expense accounting, I have cells and columns with lookup lists that are located on another sheet within the same file. I have set this up using the "Data Validation - Lists" command, for example as in the following…
Microsoft 365 and Office | Excel | For education | MacOS
How to retrieve progress of weeks on Excel doc that has suddenly disappeared
Hi, I have been working on an Excel document for weeks, making sure to save from time to time. Last night my Mac asked me to force quit Excel so I did. I vaguely remember even saving the doc before closing. Today I opened the file again but it appeared…
Microsoft 365 and Office | Excel | For education | MacOS
Excel taking too long on basic tasks and using 99,9% of CPU
Hello, I have a macbook air M3 with 8GB RAM. Lately, my excel has been taking way too long (like 10/15 seconds) doing some pretty basic tasks, like opening 'more number formats', 'more borders', 'custom format', and other stuff like that. It is happening…
Microsoft 365 and Office | Excel | For education | MacOS
my file is not letting me access
Microsoft Excel: it says my workbook is not available. It says: This workbook is either deleted or not currently accessible. I would not have deleted this. Please assist
Microsoft 365 and Office | Excel | For education | MacOS
restore a deleted file
I had an excel file with all of my important due dates and assignments. It was saved and I would always open it. It has been deleted without my consent. How to I recover this workbook?
Microsoft 365 and Office | Excel | For education | MacOS
problem when switching "bold" on and off
Hey, I'm using excel on Mac, and recently I've started to experience issues when switching "bold" on and off. For instance, when switching to bold while writing in any language that isn't english - the first letter would be english and…
Microsoft 365 and Office | Excel | For education | MacOS
On my Excel, I cannot click the main max or value button on my solver. I use MacBook Air.
So I had an assignment to use solver I did everything exactly as it is my friend has a MacBook Air, which is running on old OS and it works perfectly. I have my new MacBook Air in which I cannot click any buttons. It is very frustrating. My exams are…
Microsoft 365 and Office | Excel | For education | MacOS
How to fix Excel solver function buttons
There are no checkbox's to adjust for Max , min values , make unconstrained Variables Non-negative Mac OS - version Tahoe 26.0.1 Excel version - 16.102.1
Microsoft 365 and Office | Excel | For education | MacOS
I got charged $99.99 but I clicked free trial. How can I get a refund?
I selected a plan because it said there I could do a free trial yesterday but today when I checked my card, it was billed for $99.99. How can I get a refund?
Microsoft 365 and Office | Excel | For education | MacOS
Excel Won't Save As a PDF MacOS 15.7.1
Hi, I save my excel sheet as a PDF which allows the links in the spreadsheet to be clickable. Today I got this "Something went wrong and your file can't be saved now. Try again with the "Best for Printing" option." The problem with…
Microsoft 365 and Office | Excel | For education | MacOS
Visible Plus Sign in Cells
Hello - I am a Kindergarten teacher and am making a data page for each of my students to track their growth. I would like to have a visible + or - in a cell for parents to see if their child's score went up or down on a given assessment. How do I do…
Microsoft 365 and Office | Excel | For education | MacOS
How to transfer my Microsoft Office Specialist: Excel Associate (Office 2019) badge from Credly to my Microsoft account?
I passed the Microsoft Office Specialist: Excel Associate (Office 2019) exam with my college, and my badge was issued through Credly. I was wondering how I would transfer this badge from Credly to my Microsoft Learn account.
Microsoft 365 and Office | Excel | For education | MacOS
I accidentally unsaved an excel file when closing it is there any way to recover the original data I had in the file.
When I went to close my excel file I accidentally pressed "don't save", I was wondering if there was any way I could get the file with all the unsaved data I had in it before. If there was any recovery method to be able to get my old unsaved…
Microsoft 365 and Office | Excel | For education | MacOS
Pre made budget template sheet
Good day, I have found a few posts about this specific sheet already but nothing to fully answer my question, when using this premade template from excel for budgeting, the pie chart simply does not pull new data when the sheet is copied. It always pulls…
Microsoft 365 and Office | Excel | For education | MacOS
How to get quick analysis button on excel for mac
I was wondering if I could use the quick analysis button on mac because i cant seem to find it anywhere.
Microsoft 365 and Office | Excel | For education | MacOS
Conditional formatting question
I have a large dataset I need to review (1000+ rows). Each row contains about a dozen columns, one of which is the name of an individual. I need to check the information for each individual, and I'd like to use conditional formatting to help me do this…
Microsoft 365 and Office | Excel | For education | MacOS
LET function disappeared from latest Office 365 build—bug or update issue?
I recently updated to the latest Office 365 (Excel for Microsoft 365), and noticed that the LET function isn't recognized anymore—no IntelliSense suggestions, and formulas return a #NAME? error. There’s no mention of its removal on the official LET…
Microsoft 365 and Office | Excel | For education | MacOS
My excel file that I created last year has this error; "You don't have permission to open this workbook", any way I can view the data within?
Good day, I currently use excel in an education organisation as a student. Alongside for school, I also use it for some data and documents outside of school. This one excel file I made, contained lots of data that was not for sharing, hence I used the…
Microsoft 365 and Office | Excel | For education | MacOS
MO-201 Course Materials Link is Broken
I am currently preparing for the MO-201: Microsoft Excel Expert (Office 2019) certification exam. I attempted to download the official course materials from the Microsoft Educator Center, but I am unable to access the files. Either the link redirects to…
Microsoft 365 and Office | Excel | For education | MacOS
How to create a chart in Excel Worksheet with specific cell data that is not adjacent.
I created this spreadsheet in Excel Google Docs, but I can't seem to create a y axis through setup to chart goal 1 progress and date of sessions over time. I don't seem to have a y axis available in setup, only the x axis. How can I go about this? Do…